February 3, 2010 at 7:52 am
[font="Verdana"]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[/font]
MH-09-AM-8694
February 3, 2010 at 9:17 am
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply