October 23, 2008 at 12:23 pm
how to transfer all ssis packages from one server to other?
October 23, 2008 at 1:22 pm
You have a couple of options but an easy one is to connect to the Integration Server that currently host's the packages and, right-click on the package(s) and select Export, then you select the destination server and set a location and away you go.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 23, 2008 at 2:05 pm
i want to transfer around ~40 packages , click here and there is time consuming job
need some other solutions...
October 23, 2008 at 5:26 pm
You didn't mention if the packages are stored in SQL Server or in the file system. An advantage of storing packages as .dtsx files is you can copy them between servers easily. So, if you have all your packages in a folder, just copy the folder to the other server.
If you stored them in SQL Server, I think you're stuck with moving them one at a time like Jack suggested unless you can find a third-party tool that will do it.
Greg
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply