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 2 of 4

««1 2 3 4 »»»

Copying DTS Packages To a Different Server

Rate Topic

Display Mode

Topic Options

Author

Message

pochreyes

Posted Wednesday, March 20, 2002 7:53 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, November 20, 2012 4:27 AM
Points: 1, Visits: 5

Great article.

Let me just add my thoughts on minimizing having to edit your dts packages when you move them to a different server.

One way to avoid the need to change all those server connections in dts packages when you move them to another server is to use UDLs. you can setup UDLs in a centtral repository, say a file server and access them from that location. just make sure that you check the "always read properties from UDL file" check box.

Post #29968

Andy Warren

Posted Wednesday, March 20, 2002 8:23 PM

SSCertifiable

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

Thanks for the feedback. UDL's are handy, not just for DTS packages. Every little bit helps later on.

Andy

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

Post #29969

darren.green

Posted Tuesday, April 02, 2002 7:18 AM

Valued Member

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

Just remember that UDLs are only usefull in SQL 2000 because in SQL 7.0 they where consumed at design-time not run-time.

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

Post #29970

Lonnie Wimble

Posted Thursday, April 04, 2002 6:48 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, May 09, 2013 2:45 PM
Points: 21, Visits: 38

Having experienced migrating a Data Warehouse from SQL 7.0 to SQL 2000 (a MUST, believe me!), I discovered some very interesting issues with the DTS packages. You will discover that if you attempt to migrate DTS packages from one SQL2000 server to another, you will NOT be able to edit or delete the DTS packages if the new server has a different name....Seems that rather than embed Local in the msdb entries, it hard codes the server names into the entries...Not pretty.

Post #29971

hussaini

Posted Thursday, July 25, 2002 11:32 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, March 18, 2013 2:12 PM
Points: 8, Visits: 21

Does this VB script to move DTS, moves owner id along with the package, because when I use save as
use my userid, and then the developer cannot use it.
Thanks
Anwar

Post #29972

Andy Warren

Posted Thursday, July 25, 2002 4:37 PM

SSCertifiable

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

Yes, it does. Anything that is part of the package gets moved.

Andy
http://www.sqlservercentral.com/columnists/awarren/

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

Post #29973

nickyvb

Posted Friday, July 25, 2003 12:18 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, April 30, 2013 11:25 AM
Points: 7, Visits: 91

any suggestions on how to move dts packages from server a to server b where server a and b are totally disconnected from each other?
thanks!
-nicky

Post #29974

Andy Warren

Posted Friday, July 25, 2003 1:18 PM

SSCertifiable

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

No way to establish a temporary connection over a VPN? You can export to COM files, copy them to the other server that way. Or even export as VB code and run that against the new server. Other than that...you could BCP out the tables involved, BCP back in on the other server.

Andy
http://www.sqlservercentral.com/columnists/awarren/

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

Post #29975

dpbrown

Posted Friday, October 24, 2003 10:52 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, November 19, 2003 12:00 AM
Points: 4, Visits: 1

What platform do you code this in? I'm doing a project for school where I have to copy info from one server to another. Also does there need to be a main routine to pass the values through the function(i.e. Destination Server)?

Post #29976

Steven.

Posted Friday, October 24, 2003 3:07 PM

Right there with Babe

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 12:58 AM
Points: 739, Visits: 190

Personally I find copying the entries in the sysdtspackages table a lot easier, as described at http://www.sqldts.com/?204

Steven

Post #29977

« Prev Topic | Next Topic »

40 posts, Page 2 of 4

««1 2 3 4 »»»

Permissions