I'm trying to figure out a way to "parameterize" the data connection for SSIS packages. So I'm working with config files (and also sql server config tables).
Say I have an Oracle connection, and I'm testing a package in test d.b. And another developer has a different package using the same oracle connection. He needs to pull from Prod but I want to pull from test.
How is this accomplished ? I'm new to SSIS and have come to understand config files (and sql server config tables), but now I'm perplexed . . . because I came to the conclusion that for an Oracle connection, I would have a config file in a common location, like
And my connection is called Oracle_EDW, to keep it generic.
But if we both point to this config file, then we can't pull from diff d.b.'s, one from Prod and one from Test?
So how does one accomplish parameterizing a connection in SSIS ?