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.
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.