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

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

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy