Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

DTS package import Expand / Collapse
Author
Message
Posted Friday, December 4, 2009 11:38 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 10:54 PM
Points: 430, Visits: 1,068
Hi,

I need to import 150 DTS packages in sqlserver2005.Importing one by one shouls take lot of time.
how to import all these packages at a time.
can you please provide the query.


Thanks in advance.
Post #829138
Posted Friday, December 4, 2009 5:28 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 12:11 AM
Points: 17,823, Visits: 15,754
Since it is not guaranteed that all of the packages will properly convert, you will need to investigate the packages at the individual level. Are you sure that you will even need all 150 packages? Are any of them deprecated?

Hunker down and just start doing it.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #829314
Posted Friday, December 4, 2009 6:31 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 10:54 PM
Points: 430, Visits: 1,068
yes i need all the packages.
Post #829323
Posted Friday, December 4, 2009 10:43 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 11:52 AM
Points: 2,832, Visits: 8,513
I think I used "DTSBackup2000" tool. Free download, and pushed 100+ DTS packages from 2000 to 2005 with just a few clicks.


Post #829348
Posted Saturday, December 5, 2009 10:22 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 12:11 AM
Points: 17,823, Visits: 15,754
Yes, there are tools available. With our dts packages we see about a 50% conversion failure rate and have to manually do the conversion anyway.

One such tool that can do conversions
http://www.pragmaticworks.com/products/Business-Intelligence/dtsxchange/

ssis tutorial
http://bi-polar23.blogspot.com/2008/03/new-to-ssis-start-here.html

Conversion Article
http://www.sqlmag.com/Article/ArticleID/94095/sql_server_94095.html




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #829422
Posted Saturday, December 5, 2009 12:12 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 11:52 AM
Points: 2,832, Visits: 8,513
Are you wanting to import and convert to SSIS at the same time ? The tool I referred to just imports them as DTS running in Legacy mode.


Post #829433
Posted Saturday, December 5, 2009 8:23 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, September 18, 2014 9:16 AM
Points: 43, Visits: 250
Hi I am trying to copy DTS Packages from sql 2000 to 2005? what is the process i can do it?
Post #829484
Posted Sunday, December 6, 2009 8:23 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 11:52 AM
Points: 2,832, Visits: 8,513
sureshdeenu (12/5/2009)
Hi I am trying to copy DTS Packages from sql 2000 to 2005? what is the process i can do it?


As I recall, you can export & import them one at a time, or try the tools mentioned above.



Post #829519
Posted Sunday, December 6, 2009 4:01 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, September 18, 2014 9:16 AM
Points: 43, Visits: 250
can u pls give me step by step to copy the packages from sql 2000 to 2005
Post #829567
Posted Sunday, December 6, 2009 4:09 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, September 18, 2014 9:16 AM
Points: 43, Visits: 250
I tried to move each dts package, rt. click on it-> Open -> Save as storagefile on source server(2000)
On the destination server(2005), rt click on DTS package folder-> Import -> select the dts package storage file from the shared folder. But i couldnt open the package in destination server. wht is the best sollution for me?
Post #829571
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse