when you say DTS to SSIS
three things come to my mind
- You want to migrate a DTS package to SSIS.
for migration of DTS to SSIS, BIDS has DTS Package Migration Wizard
. right-click the Packages folder and select Migrate DTS 2000 Packages to launch the DTS Package Migration Wizard as shown below:
- you want to create a new package in SSIS to replace the DTS one.
well there is no silver bullet for this but you can start the migration tool to have a starting point or you will need to build a package from scratch.
- you want to execute a DTS package from SSIS.
for this you have a control flow item called Execute DTS 2000 Task
.