January 31, 2011 at 7:19 pm
Hi guys,
Please guide me what is the best and easiest way to transfer package from one server to other. I create a package for my client now i want to copy from my server and paste to my client server. What is the best way so i can keep all variables and everything. i know once i transfer or paste my package to my client server i have to select source path and target path am i right? Please advise me Thanks in advance.
February 1, 2011 at 3:41 am
tooba111 (1/31/2011)
Hi guys,Please guide me what is the best and easiest way to transfer package from one server to other. I create a package for my client now i want to copy from my server and paste to my client server. What is the best way so i can keep all variables and everything. i know once i transfer or paste my package to my client server i have to select source path and target path am i right? Please advise me Thanks in advance.
You can use the Import/Export package wizard on the Integration Services server, but this is a manual process.
Better is to script out the use of the dtutil utility.
Beware that even when your packages change environment, the connection managers do not (they retain their original values), unless you specify package configurations.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 1, 2011 at 8:50 am
Koen is correct.
However, it is a best practice to keep your code in a source control system, or at LEAST have a copy outside of the server. If you need to rebuild structure (ie: sprocs, tables, views, jobs, SSIS packages, etc.) you shouldn't need a database backup..
Now, with all that said, if your packages are going to be moved from environment to environment (as many are) you need to keep this in mind when you develop them. The connection managers are the one place that usually need to be modified as a package moves. It is not recommended that you physically change the package as it moves from environment to environment. You have some options, package configurations is very popular. Depending on how the job is called other options are available, if it is called from a SQL Agent job you can modify the connection managers right from the job.
CEWII
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply