Dynamic Data Source Connection

#11

Hi Sudhakara,

I need to do the same with excel connection, but, I am new to SSIS, so could
you send me a sample?

TIA

Daniela

"Sudhakara.T.P." wrote:

Quote:

Hi Allan,

Thank you very much for the reply.

Well I got hold of the solution after doing some more research on that.
Thank you very much.

Regards,
Sudhakara.T.P.

"Allan Mitchell" wrote:

Hello Sudhakara.T.P.,

Can I take it you are using SSIS?

Ok So what I would do is this

Have variables that will hold each connectionstring.

Assign them to the ConnectionString property of the relevant connection manager.

Create two file connection managers that point to the files wherein lies
the connection strings.

Using a Script task retrieve the Connection String values from the files
and assign to the relevant variable.

Should be OK.

Regards

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com

Hi,
I need to connect to Oracle 9i Server & Sql Server 2005 datasources
dynamically, wherein the connection strings needs to be retreived from
an
text file specified.
I am trying this by using Expressions and specifying that in the
Connection Manager-->Expressions box, but no luck.

Does anyone has any ideas.

Regards,
Sudhakara.T.P.
sudhakaratp (AT) hotmail (DOT) com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Dynamic Data Source Connection

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: Dynamic Data Source Connection - 09-19-2008 , 09:19 AM