Running SSIS package on SQL Server 2000 ?


Running SSIS package on SQL Server 2000 ?

by Dallastowe » Fri, 21 Nov 2008 03:24:40


I’m currently developing an import/export package in SSIS. I recently realized that this package is supposed to be run on a SQL Server 2000 instance, and I have no clue if this will work...

I’m pretty new to SQL Server, but I now that DTS from 2000 ws replaced by SSIS in 2005,

and the command-line dtsrun replaced by dtexec.

So my question: Will I be able to run a SSIS package on SQL Server 2000, and how would I do that




Running SSIS package on SQL Server 2000 ?

by ggciubu » Sun, 23 Nov 2008 04:25:41

I quote from Books Online 2005 ( look for "SQL Server 2005 Integration Services Backward Compatibility "):

"It is not possible to save or export Integration Services packages to the SQL Server 2000 DTS package format."

Anyway MS told as that DTS was rewroted to get the SSIS on SQL 2005 so SQL 2000 engine can't run 2005 packages.

But it is a false problem because you can have somewhere a SSIS server (id est SQL 2005) that can access data on SQL 2000 server (or many RDBMS systems) in a SSIS package.


Running SSIS package on SQL Server 2000 ?

by DarrenSQLI » Tue, 25 Nov 2008 05:26:42

You will have to install SSIS on the server, or you host the package on an existing SQL 2005/SSIS server, but just

point your connections at the SQL 2000 databases.

SSIS packages are not backwardly compatible with DTS, so nothing less than a SSIS installation will allow you to run a SSIS package. This means you need to license the machine as a SQL 2005 server. You can run SQL 2000 and SQL 2005 side by side quite happily if you do not wish to upgrade.