September 9, 2008 at 12:33 pm
Hi ,
SSIS newbie here! Don't know if this is possible or not so I am hoping some one might be able to point me in the right direction. I have a SSIS package that does some minimal etl for flat files. I have different flat files for different clients but they are identical in name and format. Each customers flat files also have to write to different instances of a database although identical in form and function (schema). Is it possible to have the source file directory path and the destination database name parameterized in the package so that the same package can be used for each clients files? This would seem to require a parameter used in the connection manager for each flat file identified in the package and also for the destination database but is this even possible? Has anyone tried anything similar to this scenario? Any info in this regard would be appreciated.
Thanks,
Matt
September 9, 2008 at 12:43 pm
Package configurations will allow you to configure one package for multiple sources.
Using one job per client in the Job Agent would also allow you to simply specify the connection strings within the job step.
If you need to make the decision at run-time, you can use variables and expressions to modify connection manager properties pretty easily.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply