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

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"
<anonymous (AT) discussions (DOT) microsoft.com> wrote:

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

"Sue Hoegemeier" <Sue_H (AT) nomail (DOT) please> wrote

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"
<anonymous (AT) discussions (DOT) microsoft.com> wrote:

Thanks Sue.

The analysts changed the packages to Local packages so we could use the
Migration Wizard.

Now we have migrated them we had to install the SQL2000 DTS Designer
Components, from the Feature Pack, but we still cannot see the migrated
packages. I remember an article by Brian Moran in SQL Mag on how to fix this
problem but I don't have the article on hand.

Can someone tell me the fix please? I think it had to do with the registry.

Thanks

Chris

"Sue Hoegemeier" <Sue_H (AT) nomail (DOT) please> wrote