Copying DTS Packages To a Different Server

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Andy Warren » Copying DTS Packages To a Different Server

40 posts, Page 1 of 4

1 2 3 4 »»»

Copying DTS Packages To a Different Server

Rate Topic

Display Mode

Topic Options

Author

Message

Andy Warren

Posted Saturday, March 16, 2002 12:00 AM

SSCertifiable

Group: Moderators
Last Login: Thursday, May 09, 2013 12:38 PM
Points: 6,462, Visits: 1,384

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/awarren/copyingdtspackagestoadifferentserver.asp>http://www.sqlservercentral.com/columnists/awarren/copyingdtspackagestoadifferentserver.asp

Andy
SQLShare - Learn One New Thing Each Day
SQLAndy - My Professional Blog
Connect with me on LinkedIn
Follow me on Twitter

Post #3063

Simon Galbraith

Posted Monday, March 18, 2002 7:28 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, February 14, 2012 9:05 AM
Points: 6, Visits: 44

Red Gate Software are working on a new product to help people out in comparing and synchronizing the different settings between different SQL Servers. It will be called SQL Server Compare. It will compare DTS packages, logins, jobs and server settings. The idea is to save DBAs who have to administer and set up multiple SQL Servers a whole load of time. It should be launched before the end of April. People interested in the Beta (and in influencing what functionality we include) please contact us at: sqlservercompare@red-gate.com
Cheers,
Simon Galbraith

Post #29959

retreif

Posted Wednesday, March 20, 2002 10:26 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, October 15, 2008 6:19 AM
Points: 133, Visits: 4

moving DTS packages is as easy as using save-as and picking the other server...

Post #29960

Andy Warren

Posted Wednesday, March 20, 2002 11:09 AM

SSCertifiable

Group: Moderators
Last Login: Thursday, May 09, 2013 12:38 PM
Points: 6,462, Visits: 1,384

Depends on how many you're moving doesn't it? I wrote this after someone asked for help moving more than 200 packages.

Andy

Andy
SQLShare - Learn One New Thing Each Day
SQLAndy - My Professional Blog
Connect with me on LinkedIn
Follow me on Twitter

Post #29961

Antares686

Posted Wednesday, March 20, 2002 11:14 AM

SSCrazy Eights

Group: Moderators
Last Login: Tuesday, April 09, 2013 12:53 PM
Points: 8,357, Visits: 684

I haven't had a chance yet to test it, but it is an interesting concept for moving DTS packages that I will have to play with it. Good job.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Post #29962

retreif

Posted Wednesday, March 20, 2002 11:39 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, October 15, 2008 6:19 AM
Points: 133, Visits: 4

I guess my point was if you have to go in to review each DTS package to check if pathing whatever is correct then file save as works as well as spending the time to get this working. I'm not saying this isn't a slick way to automate if you can be sure. Sorry I didn't express that better the first time.

Post #29963

darren.green

Posted Wednesday, March 20, 2002 1:35 PM

Valued Member

Group: General Forum Members
Last Login: Friday, May 05, 2006 1:47 PM
Points: 69, Visits: 1

The limitation of the wizard not allowing you to transfer system tables can be overcome by building the package manually.

Transferring DTS Packages
http://www.sqldts.com/main.asp?nav=1,6,204,0

Darren Green
SQLDTS.com | SQLIS.com | Konesans Ltd

Post #29964

Andy Warren

Posted Wednesday, March 20, 2002 1:50 PM

SSCertifiable

Group: Moderators
Last Login: Thursday, May 09, 2013 12:38 PM
Points: 6,462, Visits: 1,384

Retreif - I agree. You either have to spend extra time (possibly anyway) when you build it to make it portable or live with the consequences if/when you have to move it. I figure you could at least do the bulk move, then edit the ones you knew you had to fix, then see whats left!

Darren - thanks for the link. Should have looked there first! Fun to explore though. Have you considered participating in the beta test mentioned above?

Andy

Andy
SQLShare - Learn One New Thing Each Day
SQLAndy - My Professional Blog
Connect with me on LinkedIn
Follow me on Twitter

Post #29965

retreif

Posted Wednesday, March 20, 2002 4:25 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, October 15, 2008 6:19 AM
Points: 133, Visits: 4

I sometimes think only in my world too, I never know what to expect in the package I develop in and maintain. Too many different "styles" to count on any thing working like that. I'm also glad not to be working in app with 200 or more DTS packages transferring data between data sources!

Post #29966

Andy Warren

Posted Wednesday, March 20, 2002 4:33 PM

SSCertifiable

Group: Moderators
Last Login: Thursday, May 09, 2013 12:38 PM
Points: 6,462, Visits: 1,384

Aint that the truth!

Andy

Andy
SQLShare - Learn One New Thing Each Day
SQLAndy - My Professional Blog
Connect with me on LinkedIn
Follow me on Twitter

Post #29967

« Prev Topic | Next Topic »

40 posts, Page 1 of 4

1 2 3 4 »»»

Permissions