upgrade DTS packages automatically ?

upgrade DTS packages automatically ?

Post by U3RldmUgT » Wed, 31 Mar 2010 13:11:01

Hi -

I'm not familar with DTS deatils. I was wondering if Microsoft has a tool in
either SQL 2k5 or SQL 2k5 SSIS which "converts" SQL 2k DTS packages into
something editable and runable in SQL 2k5/2k8 ? Does such a tool exist, or am
I going to have to re-write all of this stuff ?



upgrade DTS packages automatically ?

Post by VG9kZCB » Wed, 31 Mar 2010 21:36:01

Yes. In SQL @005 and 2008 you use the SQL Server Management Studio (SSMS) to
conntect to your existing DTS Packages (under the Management >> Legacy node).
Right click on an existing DTS Package and select Migrate. The wizard will
walk you through creating an SSIS equivalent package. Note that not
everything is convertable and you should open the new package(s) in Visual
Studio/BIDS to see what the wizard created. You may need to do some manual
tweaking to get it to work.

I suggest you store your new SSIS Packages in the MSDB database (it's one of
the options).


Good luck.
Todd C
MCTS SQL Server 2005