Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tooba111
Starting Member
22 Posts |
 Posted - 2014-04-04 : 14:09:35
|
| Hi Guys, 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 theform X = Y, separated by semicolons."Any Help would be great appreciate or any other easy solution. Thank You. |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-04-07 : 15:23:09
|
| I think most folks use SSIS configurations for this sort of thing. You can store your connection strings in a database table or an xml file e.g. Google on SSIS configurations and Connection Strings. It takes a bit to set it up but is worth the hastle. |
 |
|
|
|
|
|
Variable as a OLEDB Connection