I already converted over several databases to SQL 2005 (i'm still running
them under sql 2000) for testing. Now I need to convert several DTS packages
that are on my SQL 2000 Server to my SQL 2005 server.How do I go about doing
this without creating everything again from scratch?

Hello Mike,


OK so whilst I understand you may want to migrate the packages here are a
couple of things to think about

1. You don't have to. You can call and use DTS packages in SSIS "AS IS"
and they function very very well.
2. I am always inclined to rewrite from scratch. There is no way the wizard
has a hope of converting a lot of my packages as they use Active Script Task
and transforms and that is very difficult for the boys and girls at MS to
cater for. When I do run the conversion wizard against them then they invariably
do not work.

Have a look here

http://wiki.sqlis.com/default.aspx/SQLISWiki/UpgradingDTS.html

--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

[quoted text, click to view]