Skip to Content
Nov 24, 2009 at 03:30 PM

Data Services: Parameterize source and target tables


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.