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: Monday, September 15, 2014 10:24 AM
Points: 424, Visits: 1,049
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: Yesterday @ 10:58 PM
Points: 17,600, Visits: 15,461
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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
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: Monday, September 15, 2014 10:24 AM
Points: 424, Visits: 1,049
yes i need all the packages.
Post #829323
Posted Friday, December 4, 2009 10:43 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 1:06 PM
Points: 2,827, Visits: 8,479
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: Yesterday @ 10:58 PM
Points: 17,600, Visits: 15,461
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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #829422
Posted Saturday, December 5, 2009 12:12 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 1:06 PM
Points: 2,827, Visits: 8,479
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: 2 days ago @ 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: Wednesday, September 10, 2014 1:06 PM
Points: 2,827, Visits: 8,479
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: 2 days ago @ 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: 2 days ago @ 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