Jim Youmans
asked on
Set Up SSIS data source to use a system environment variable
SQL Server 2012 and VS 2013 for SSIS.
I want to set up a connection in my packages to point to a configuration table for the packages other connections (OLE DB, Flat File, and Excel). I have read you can use a system environment variable to do that so that when you promote the packages to different servers, it will pick up the environment variable (named the same) and point the package to the correct configuration table on that server (for dev, test, and prod).
I have a system environment variable set up (SSIS_Config) with the connection string for the SSIS Configuration table in it on the server and a data source (dsSSISConfig) in each package to connect to the SSIS Configuration table. There are a couple of other data sources in the packages that I want to config from the SSIS Configuration table and have it set up for them.
So how do I make the dsSSISConfig data source use the system environment variable SSIS_Config? Can I do that? I can't seem to find a good example of how to set it up. Any help would be greatly appreciated.
Thank you!
Jim
I want to set up a connection in my packages to point to a configuration table for the packages other connections (OLE DB, Flat File, and Excel). I have read you can use a system environment variable to do that so that when you promote the packages to different servers, it will pick up the environment variable (named the same) and point the package to the correct configuration table on that server (for dev, test, and prod).
I have a system environment variable set up (SSIS_Config) with the connection string for the SSIS Configuration table in it on the server and a data source (dsSSISConfig) in each package to connect to the SSIS Configuration table. There are a couple of other data sources in the packages that I want to config from the SSIS Configuration table and have it set up for them.
So how do I make the dsSSISConfig data source use the system environment variable SSIS_Config? Can I do that? I can't seem to find a good example of how to set it up. Any help would be greatly appreciated.
Thank you!
Jim
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER