all groups > sql server dts > september 2006 >
You're in the

sql server dts

group:

Migrating DTS packages from SQL2000 to SQL2005



Migrating DTS packages from SQL2000 to SQL2005 Chris Wood
9/19/2006 8:04:56 AM
sql server dts: Hi,

My initial tests show that this feature will only see DTS Local Packages.
How can we migrate the DTS Meta Data Services Packages?

Thanks

Chris

Re: Migrating DTS packages from SQL2000 to SQL2005 Sue Hoegemeier
9/19/2006 9:16:55 AM
The requirements for migrating DTS packages saved to the
repository are explained in Books Online help topic:
Using the Package Migration Wizard
http://msdn2.microsoft.com/en-us/library/ms143496.aspx

-Sue

On Tue, 19 Sep 2006 08:04:56 -0600, "Chris Wood"
[quoted text, click to view]
Re: Migrating DTS packages from SQL2000 to SQL2005 Chris Wood
9/19/2006 10:07:43 AM
Sue,

This mentions Repository packages only if SQL2000, SQL2000 tools or the
Repository files are present on the local computer, the server that the
Migration Wizard is being run on I assume? As we have msdb as our Repository
we would have to migrate the SQL2000 msdb to the SQL2005 to find the Meta
Data Services packages?

Thanks

Chris

[quoted text, click to view]

Re: Migrating DTS packages from SQL2000 to SQL2005 Sue Hoegemeier
9/19/2006 8:16:15 PM
Yes...on the server where the migration wizard is being run.
The wizard needs the repository files to read the packages.
You just need the repository redistributable files on that
server.

-Sue

On Tue, 19 Sep 2006 10:07:43 -0600, "Chris Wood"
[quoted text, click to view]
AddThis Social Bookmark Button