Can we use DTS package from SQL server 2000 in 2005

Question

Can we use DTS package from SQL server 2000 in 2005

Patrick.I

Hall of Fame

Points: 3105
More actions
October 23, 2008 at 4:45 pm

#131796

When migrating from sql srv 2000 to 2005 can we use the same DTS packages in 2000 in 2005?
Is this proper or does it have some limitations.
Thanks

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

Greg Charles SSC-Forever Points: 45403 More actions · Answer 1

DTS Packages will still work in SQL 2005. Packages are not automatically upgraded when you upgrade to SQL 2005 and if you migrate i.e. transfer everything from a SQL 2000 instance to a SQL 2005 instance, you can import DTS packages as is. If you execute the packages in jobs, they'll work just the way they did in SQL 2000.

You'll need to download and install the SQL 2000 DTS Designer components http://www.microsoft.com/downloads/details.aspx?FamilyID=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&displaylang=en to be able to use DTS Designer to modify packages.

Greg