> 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@hotmail.com

"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@hotmail.com
>
>