I have a question on Dynamic Connection Strings, In my current assignment a team of 4 developers are working on the same source and different targets. We were thinking of creating a dynamic connection strings for the source and targets.
Do i need to go about using the SQL Server package configuration and variables adding all the credentials into a table and then working or is there a better way?
We are not trying to promote the packages through DEV/STG/PROD.we'll be trading packages from one machine to another down the line,so wanted to know which would be the best approach .
Since your requirments are not too complex, you might just want to use the XML configuration files. You can put the appropriate file in the exact same file location on each machine and just change the connection strings and variable values in the file.
Thanks Kathi i'll give it a try