Need Help,I want to know what is the best way to deal this kinda Problem or approach.
I am creating almost 30 SSIS Packages, some of them or simple and some of them are really tough (SCD and Other Transformations),
First I am gonna run SSIS Packages on Test Server then Dev Server and then Finally Production.
Its to much for me to every time change OLE DB Connection, and recreate SCD mapping and everything.
I want to know If I can use OLEDB Connection as a VARIABLE, Instead of change all OLEDB Connection, just change one VARIABLE.
If I create Variable as a CONNECTIONString, I am having a error something like " It must consist of one or more components of the
form X = Y, separated by semicolons."
Any Help would be great appreciate or any other easy solution.