SQL Server 2005 Tidbit 023

SQL Server 2005 Tidbit 023

“What’s gonna happen to my DTS packages, now that SQL Server 2005 has this new SSIS (SQL Server Integration Services)?”

Well.. you’ve got several options.

The SQL Server 2005 Books Online has hefty document all about it in the “Upgrading to SQL Server 2005” section.

You basically have three choices:

• You can migrate DTS packages to the SQL Server 2005 format,
• Continue to run DTS packages by using the SQL Server 2000 DTS runtime, or
• Incorporate DTS packages into SQL Server 2005 Integration Services solutions by using the Execute DTS 2000 Package task.

You also might want to look at the information on Backward Compatibility.

—

Got an IT question?  Give me a comment, or contact me.