how to check DTS packages require changes in order to work on 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 » how to check DTS packages require changes in...

how to check DTS packages require changes in order to work on SSIS

Rate Topic

Display Mode

Topic Options

Author

Message

MSQLDBA

Posted Friday, November 28, 2008 4:49 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, June 21, 2012 8:49 AM
Points: 129, Visits: 551

Hi dear all,

i have created SSIS for DTS packages migration. Now the my problem is that how i can check the DTS packages require changes in order to work on SSIS. I am not understanding how to check this situation.

Thanks in advance.
rgrds,
m.i.

________________________________________
M.I.

Learning is a path with no destination...

Post #610256

shmuel_v

Posted Monday, December 01, 2008 3:49 AM

Grasshopper

Group: General Forum Members
Last Login: Sunday, February 03, 2013 12:21 AM
Points: 22, Visits: 151

Hi,

What you need is : Microsoft SQL Server 2005 Upgrade Advisor.

[url=http://www.microsoft.com/downloads/details.aspx?FamilyID=1470e86b-7e05-4322-a677-95ab44f12d75&displaylang=en][/url]

Post #611129

CozyRoc

Posted Monday, December 01, 2008 9:27 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 10:02 AM
Points: 1,106, Visits: 2,115

Check also DTS xChange.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Post #611435

Justin Lezon

Posted Tuesday, December 02, 2008 5:47 AM

Ten Centuries

Group: General Forum Members
Last Login: Friday, May 17, 2013 7:41 PM
Points: 1,101, Visits: 843

Are you looking for a way to edit a DTS 2000 package that has been migrated to SSIS 2005? This article explains how to do that.

[url=http://wiki.sqlis.com/default.aspx/SQLISWiki/EmbeddingDTS2000PackagesInSSIS.html][/url]

Post #611987

« Prev Topic | Next Topic »

Permissions