ETL ConnectionStrings

[Louis Haußknecht]

Hi,

I need to configure my OutputCommandOperations to connect to different
SQL Server instances. I need to set these instances at runtime.

I'd rather like to pass in a connectionString to the Operation ctor
instead of an app.config key for the connectionstring.

Any ideas on that?

[Simone Busoli]

You can modify the source to accept a connection string I guess.

2009/10/16, Louis Haußknecht <l...@haussknecht.com>:

--
Inviato dal mio dispositivo mobile

[Stuart Laughlin]

When I needed to do this, I got around it by altering the app.config
at runtime. In other words, one of the first things my app did was to
add a bunch of connections to the app.config file. I wasn't exactly
proud of myself, but it gets the job done. :)

--Stuart