SSIS has a great feature called indirect configuration. It is used to store the configuration access path into the computer’s environment variable. This feature greatly facilitates the deployment of an SSIS solution. All we have to do is to set the environment variable on the target computer and all packages in the solution automatically point to the right place.
There are two types of configuration: Direct and Indirect.
Direct configuration: the configuration path directly will store in
Package.
Indirect configuration: the
configuration path will store in an Environment variable value.
The indirect configuration will make
the configuration path dynamic, and the admin can change the configuration path
in the environment variable value.
Read more about
Registry configuration :
https://bageshkumarbagi-msbi.blogspot.com/2020/09/ssis-package-configuration-using.htmlEnvironment configuration :
https://bageshkumarbagi-msbi.blogspot.com/2020/09/ssis-package-configuration-using.html
No comments:
Post a Comment
If you have any doubt, please let me know.