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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy