May 27, 2014 at 9:15 am
Hello,
I have deployed a project with multiple packages to SSIS 2012 db. I am able to configure the project parameters fine. But, I am not able to replace the package variable values with the 'Environment' variables.
Any idea how I can do this.
Thank you
May 27, 2014 at 12:50 pm
1. Create the environment variable and give it a value.
2. Go to the project configuration and go to references. Add a reference to the environment.
3. Click OK. Open up the configuration window again. Now go to a variable and choose the environment variable from the dropdown.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 27, 2014 at 1:02 pm
Hi,
Thank you very much for the response. I came to know that we can not set the Package Variables' in 'SSISDB 2012 project deployment' for individual packages. So, we will have to use 'Package Parameters' to be able to configure the values on individual packages, dynamically on the deployment server. So I started using package parameters. It worked fine.
Sorry I wish I could put the screenshots.
Again thank you very much for your help.
Regards
May 27, 2014 at 1:08 pm
vanamali (5/27/2014)
Hi,Thank you very much for the response. I came to know that we can not set the Package Variables' in 'SSISDB 2012 project deployment' for individual packages. So, we will have to use 'Package Parameters' to be able to configure the values on individual packages, dynamically on the deployment server. So I started using package parameters. It worked fine.
Sorry I wish I could put the screenshots.
Again thank you very much for your help.
Regards
Right, I forgot that you had to use parameters. Parameters can be set at start-up of a package, but cannot change during runtime, but variables can.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply