Migrating DTS Packages to SSIS

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » Migrating DTS Packages to SSIS

Migrating DTS Packages to SSIS

Rate Topic

Display Mode

Topic Options

Author

Message

Sunil Kumar P T-457024

Posted Monday, October 08, 2007 7:45 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, June 21, 2010 6:10 AM
Points: 13, Visits: 62

Hi all,

Can any body tell me how to migrate SQL Server 2000 DTS packages to SSIS, i am in very much need of it... i have 5 packages in my sql server 2000 i need to migrate that to SQL Server 2005.. please help me out\

Rgrds
Sunil

Post #407985

Steve Jones - SSC Editor

Posted Monday, October 08, 2007 10:26 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 11:20 AM
Points: 31,437, Visits: 13,752

There's a DTS 2000 runtime for SQL Server 2005 so you can run them. Otherwise, rewrite them in SSIS.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #408089

Sunil Kumar P T-457024

Posted Monday, October 08, 2007 10:01 PM

Grasshopper

Group: General Forum Members
Last Login: Monday, June 21, 2010 6:10 AM
Points: 13, Visits: 62

I successfully completed migration of DTS packages from sql server 2000 to sql server 2005. but afer migration i am not able to see dts packages.

Is there any step still pending to view this dts packages?

Post #408277

abhishekbaluni

Posted Thursday, February 25, 2010 7:59 AM

Valued Member

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 4:01 PM
Points: 57, Visits: 42

check on the 2005 console -> management - > legacy -> dts you should see them there

Post #872762

« Prev Topic | Next Topic »

Permissions