Hello Everyone,

Will upgrading from SQL 2000 Standard Server to SQL 2005 Standard Server
break my exisiting dts packages? We have a large number of packages and I am
hoping that I will not have to recreate them.

TIA,

Some things will break. If you used the DTS object model in ActiveX scripts,
in particular the Parent property, then that is not supported in 2005. The
dynamic properties task is also not supported in 2005. These are just two
examples.

If you are not ready to upgrade your packages, you could consider leaving
them as DTS packages and running them from 2005. To do this, you need to use
the Execute DTS Package task to call your DTS packages.

Hope this helps.

Charles Kangai, MCT, MCDBA

Author of Learning Tree's 4-day course: "SQL Server 2005 Integration
Services" http://www.learningtree.com/courses/134.htm
Author of Learning Tree's 4-day course: "SQL Server Reporting Services"
http://www.learningtree.com/courses/523.htm


[quoted text, click to view]