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

DTS deployment Expand / Collapse
Author
Message
Posted Wednesday, February 3, 2010 7:52 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, August 29, 2014 2:57 AM
Points: 1,098, Visits: 1,222
Hi All,

I have more than 35 DTS packages which needs to be deploy on one of the new server. Can anybody tell me is there a way, so that I can deploy such packages from source server to destination server in a single run?

What I found is, Save As all packages on source server in SQL Server so that I can develop a new package to transfer these packages from source's msdb..sysdtspackages table to destination's msdb..sysdtspackages.

I haven't tried it yet, can anybody explain, is this a way to deploye bulk DTS packages from one server to another server in a single run?

Thanks in advance,

Mahesh


MH-09-AM-8694
Post #858692
Posted Wednesday, February 3, 2010 9:17 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Monday, December 15, 2014 12:03 PM
Points: 4,064, Visits: 5,372
I've done that, but I've come to prefer this tool: http://www.sqldts.com/242.aspx. It's way easier to use and is dead dependable...and it's free.

Greg
Post #858798
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse