Set Variable from External Config File in Ssis
In Ssis I Want to Set Variable Value from an External Configuration File. Let's Say I Have [User: :Fullpath] Variable and I Want to Set It Value from an...
In SSIS I want to set variable value from an external configuration file. let's say I have [User::FullPath] variable and I want to set it value from an external config file so I can change my path dynamically.
1 Answer
You have not specified what uses you need for this "variable", and this important for the answer.
Anyway, as far as I know, it depends on your deployment model on SSIS.
- Project deployment model
- Package deployment model
Integration Services supports two deployment models, the project deployment model and the legacy package deployment model. The project deployment model enables you to deploy your projects to the Integration Services server.
Deploy Integration Services (SSIS) Projects and Packages
For Package deployment model
Legacy Package Deployment (SSIS)
See "Package Configurations".
For Project deployment model
Setup Environment Variables in SQL Server Integration Services
Marcus Vance is a cybersecurity auditor and technology writer dedicated to educating the public about online safety, data privacy regulations, enterprise security, and emerging cyber threats.
