Hands-On Microsoft SQL Server™ 2005 Integration Services

Embedding DTS 2000 Packages in Integration Services Packages

Integration Services lets you to create business solutions using a modular design so you can build your package as a small unit of work to provide a piece of functionality that can be repeatedly used in various enterprise solutions. You can integrate these smaller units of work to form a complete solution using the Execute Package task. You learned about the Execute Package task in Chapter 5 and used it to build a solution in one of the Hands-On exercises as well. This is relevant if you are developing a new piece of functionality. What about the work that has been developed already using DTS 2000 packages? Do you have to develop that functionality in Integration Services? Various scenarios ...