I would like to use a SQL Server table as a source for all connection manager values within . I would like to be able to easily switch which environments i am looking at based on an input value when the project opens. The reason i need to do this is because when creating our projects in dev I use different connections than when deploying them to prod, and i have hundreds of different connections being used. I don't want to have to switch anything in SSIS or in SQL Server Agent or the SSIS Catalog. I would love for these to be strictly maintained within a SQL Server table.
- How can we have these values fed from a SQL Server table into variables that feed the values or parameters? To reiterate, the end product would have 1 single table in SQL Server that contains all columns like
[sql ConnectionString], excel connection string , flat file connection string
[Password], source file path location , target path location etc. i would parameterize all connection managers that would have their values fed from this table. Please advise