DTS deployment

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » In The Enterprise » DTS deployment

DTS deployment

Rate Topic

Display Mode

Topic Options

Author

Message

Mahesh Bote

Posted Wednesday, February 03, 2010 7:52 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, February 21, 2013 6:22 AM
Points: 1,074, Visits: 1,205

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

Greg Charles

Posted Wednesday, February 03, 2010 9:17 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 9:28 AM
Points: 4,007, Visits: 4,854

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 »

Permissions