How to port my SSIS package - how to do it?

I know how to create SSIS packages and get data sources and destinations. But what do I need to do in my package if I want to make it portable in the sense where I can change the source and target connection strings when I transfer my package to another computer?

+3
source share
2 answers

A couple of options. Do you want the solution to be portable so that you can run on different computers, or do you want you to carry the portable package to the end?

You can use package configurations for both. They are available in the SSIS / Configurations menu. You specify the properties of the objects you want to make dynamic, and this is saved in the XML file (for example, connection strings, path locations, variable values).

You can change this xml file in a text editor, and when the package is launched, it will use these values. However, if you work on multiple machines, this is still a little ridiculous. You may need to re-specify which configuration file to use when opening the solution on a new PC.

Instead, if these are DB connection strings, look at using trusted connections. They mean that you do not need to enter SQL credentials. If this is a place for files, this will not work, but you can replicate directory structures or something like that.

, , , . , , " ". , Build. , , / .

- : http://vyaskn.tripod.com/sql_server_2005_making_ssis_packages_portable.htm

+4

. , . , , .

"false".

> ... > > CreateDeploymentUtility = true

+1

Source: https://habr.com/ru/post/1709171/


All Articles