upgrade DTS packages automatically ?

[Steve M]

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 ?

Thanks,

Steve

[Todd C]

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).

HTH

Good luck.
--
Todd C
MCTS SQL Server 2005

Post by Steve M
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 ?
Thanks,
Steve