We have configured Integration Services Catalog and deployed project and created two environments. Now we need to make relation between environments and deployed projects. To do that, right click on deployed project and choose configure
In next window, we need to click on References and click on Add button, then it will prompt us to choose one environment as shown in below screen
Then click on Ok and choose Parameters tab
After this configuration, what happens inside is First Value inside environment Variable Connection 1 in DEV environment, will pass to Project Parameter DataBaseConnection and over writes it values at project level. Next from Project parameter value will pass to package connection string and it will overwrites connection string
Simply:
DEV environment Connection 1 à Project Parameter DataBaseConnection à package connection string
In next window, we need to click on References and click on Add button, then it will prompt us to choose one environment as shown in below screen
Then click on Ok and choose Parameters tab
After click on Parameters tab, click on right side highlighted button and it will lunch you another window to edit value of parameter. To make use of environment DEV, choose Use environment Variable and choose Connection 1
After this configuration, what happens inside is First Value inside environment Variable Connection 1 in DEV environment, will pass to Project Parameter DataBaseConnection and over writes it values at project level. Next from Project parameter value will pass to package connection string and it will overwrites connection string
Simply:
DEV environment Connection 1 à Project Parameter DataBaseConnection à package connection string
Kiran Reddy A
Kiran has been a part of the IT industry for more than six years and Involved in many MSBI projects and product development with extensive usage of ETL and Reporting tools like SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Service (SSRS) and T-SQL
Get Free Email Updates to your Inbox!
