Can I "parameterize" source and target SQL tables in a Data Services job that could be chosen at run time depending on what environment they were running in? I.e. PRD or Dev.
I can do this with flat files, (by parameterizing the file path), but I dont know how to do this with transparent tables.
Please advise.