SQL Server Performance

Run SSIS Package on 2000 Database Server

Discussion in 'SQL Server 2005 Integration Services' started by daustinash, Jul 26, 2006.

  1. daustinash New Member

    I have a database running on Sql Server 2000 sp3. I also have a perfect opportunity to use SSIS to do a data bridge in this database. I know I can use BIDS to connect to the 2000 DB and design/run the job from my desktop.

    The question is can I run the SSIS package ON the Sql Server 2000 machine? Will it run if I install it as a structured file and install the SSIS components/service on the 2000 machine, or does it require that the Sql Server 2005 engine/service be present.

    I've been able to find articles about compatibility running 2000 DTS packages on Sql Server 2005 machines, but nothing the other way around.

    The last thing I want to do is screw up my 2000 server by installing SSIS and find out I still can't run the SSIS package anyway.

    Thanks,

    dn

    daustinash
    dnash@verndale.com
  2. waqar Member

    Hi,<br /><br />I don't think it is possible, But i never test it [<img src='/community/emoticons/emotion-11.gif' alt='8)' />].<br />I will test it today at my personal home computer and will update tonight if it works [<img src='/community/emoticons/emotion-1.gif' alt=':)' />].<br /><br />Waqar.<br /><br />________________________________________________<br />~* Opinions are like a$$holes, everyone got one. *~

Share This Page