Help on Importing DTS package from SQL SEVER 2000 to SQL SERVER 2005 - Integration Services (SSIS) and DTS

Member of the LearnItFirst.com Video Training Network	\| LearnSqlServer.com \| SQL SSIS Training \| SQL Programming Tutorials \|

Welcome Guest

Search | New Posts | Members | Log In | Register

LearnSqlServer.com's SQL Server Forums » SQL Server Database Administration » Integration Services (SSIS) and DTS » Help on Importing DTS package from SQL SEVER 2000 to SQL SERVER 2005

Help on Importing DTS package from SQL SEVER 2000 to SQL SERVER 2005

Options

Previous Topic · Next Topic

raaz

Posted: Tuesday, July 31, 2007 4:13:22 AM

Rank: Junior DBA

Joined: 5/17/2007
Posts: 59
Points: 189
Location: India

Hi,

I am trying to import DTS package from SQL SERVER 2000 to MS SQL 2005 using Package Migration Wizard.

I am getting the following error.

Quote:
Migrating the packages...

- test_2000_dts (Stopped)
Messages
Exception of type 'Microsoft.SqlServer.Dts.MigrationWizard.HelperUtility.DTSMWException' was thrown. (Microsoft.SqlServer.DtsMigration)
ADDITIONAL INFORMATION:
Exception of type 'Microsoft.SqlServer.Dts.MigrationWizard.HelperUtility.DTSMWException' was thrown. (Microsoft.SqlServer.TasksMigrationModules)

Any help to resolve this..

Thanks In advance

Scott Whigham

Posted: Thursday, August 02, 2007 9:08:03 AM

Rank: Super Mod

Joined: 3/20/2006
Posts: 345
Points: 748
Location: Dallas, TX

hmmm = I've never seen that error before and a quick Google search returns this thread as the only match Frown

A few questions - are you using the most up-to-date version of the Package Migration Wizard (SP2)? Does the Upgrade Advisor report on your packages return any known issues or errors?

raaz

Posted: Monday, August 06, 2007 4:49:07 AM

Rank: Junior DBA

Joined: 5/17/2007
Posts: 59
Points: 189
Location: India

After installing SP2 and i tried and package got migrated.

But still the connection string of the package still pointing to the 2000 instance with that user id and login.

Do we need to manually edit that in the designer (to edit it was actully needs SQL SERVER 2005 DTS designer component to be intalled)? Or Is Any other option exists?

I really need this to complete the migration job.

Thanks in Advance....

Scott Whigham

Posted: Tuesday, August 07, 2007 11:54:31 AM

Rank: Super Mod

Joined: 3/20/2006
Posts: 345
Points: 748
Location: Dallas, TX

That's the problem with DTS is that your connections were so "deep" into the package that any migration tool has a difficult time with them. You will have to change them manually since the Package Migration Wizard does not know which server you want to use.

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.