O'Reilly logo

Professional SQL Server™ 2005 Integration Services by Mike Murphy, Haidong Ji, Jason Gerard, Erik Veerman, Andy Leonard, Kathi Kellenberger, Douglas Hinson, Darren Green, Allan Mitchell, Brian Knight

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

  1. Open BIDS, if it is not yet opened. Create an empty package.

  2. Make sure the Control Flow tab is selected. Move to the Toolbox and select the task called Execute DTS 2000 Package task.

  3. Drag the task to the Control Flow design surface. Right-click on this item ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required