CODEWITHSUNDEEP
sql-serverssismigrationdts
wil
wil

Reputation: 31

Does anyone know of a way to migrate DTS to SSIS?

Are there any tools available for this type of package conversion?

Upvotes: 3

Views: 176

Answers (3)

Keng
Keng

Reputation: 53101

You don't HAVE to do it. You can create new DTS packages in 2005 and probably 2008 by making a copy of an existing dts package and then modifying it.

If you do migrate them automatically, you will also need to do a manual code review for each one to make sure it did it correctly.

Also don't forget to check out MS' migration issues.

http://technet.microsoft.com/en-us/library/ms143462.aspx

BTW: "...custom tasks cannot be migrated, and some scripts in ActiveX Script tasks or in data transformations cannot be migrated."

Upvotes: 2

Paul Sasik
Paul Sasik

Reputation: 81479

Yes. Sql Server 2008 features a DTS package migration wizard. And here's an MSDN link to get you started.

Upvotes: 3

CodeMonkey1313
CodeMonkey1313

Reputation: 16011

you can choose to run the DTS package within an SSIS package, and I think that Visual Studio BITS has a conversion wizard (though I'm not 100% positive).

Upvotes: 0

Related Questions