November 24, 2006 at 9:42 am
Hello,
What tool could be used to make conversion of DTS package to SSIS?
Thanks.
November 24, 2006 at 10:50 am
BIDS (Business intelligence Development Studio) has within it a DTS migration wizard- open up a project and you will see SSIS Packages on the right had side- Right click and select Migrate DTS packages- it will walk you through the process - But unless they are pretty basic DTS you will need to rewrite some of the steps - Transformations/ActiveX steps etc.. BOL has a lot more info on this process as well just do a search for migrate DTS..
Thanks
Rich
November 26, 2006 at 11:50 pm
...and: In order to edit and view the DTS-Files, you need to download the "DTS Designer Components" from Microsoft.
December 6, 2006 at 5:45 am
Thanks for the help!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy