August 25, 2010 at 6:04 pm
Let say I have a package that transform and load for Region A (in DB A).
I want to reuse the package to transform and load for Region B (in DB B)
How do I make use of the configuration files to point to different DB when processing a different region?
Or do I have to pass the connection string as a parameter into the package?
Is there a way to do it with indirect configuration files?
August 26, 2010 at 5:05 pm
You could setup package configurations and use expressions to change the servername in the connection string.
You can pass them in during the run as well.
CEWII
August 26, 2010 at 5:13 pm
Elliott is spot on.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 26, 2010 at 5:20 pm
Err... This is all in 1 server but multiple databases with the same set of tables.
I want to create 1 package that can be used with multiple databases doing the same thing.
August 26, 2010 at 5:26 pm
That doesn't change the options.
To help zero in on the best choice, how do you intend to execute the package?
CEWII
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply