12.3. Running DTS 2000 Packages under SSIS
You could migrate the sample package created earlier successfully, because the tasks within are pretty simple. However, for a DTS 2000 package that uses lots of custom extensions, ActiveX scripts, and Dynamic Property tasks, the migration will not be that easy. These tasks have many interactions with the DTS 2000 object model, and the SSIS object model is not backward compatible. For those packages, you may have to do some new design and development work in order to migrate them to SSIS.
As a temporary solution, you can choose to run DTS 2000 packages under SSIS, if you have the Data Transformation Services 2000 runtime installed. You need to rerun the setup process to install the runtime if you did not do it the first time. You can choose to include this component by clicking the Advanced option during your installation process. However, if you already have SQL Server 2000 client tools installed, especially Enterprise Manager, then the runtime is already present on the server and you will not see this optional component during your installation process.
In this section, you will learn how to run a DTS 2000 package within SSIS. You will use your earlier sample package as an example.
Open BIDS, if it is not yet opened. Create an empty package.
Make sure the Control Flow tab is selected. Move to the Toolbox and select the task called Execute DTS 2000 Package task.
Drag the task to the Control Flow design surface. Right-click on this item ...
Get Professional SQL Server™ 2005 Integration Services now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
