Hello All,

Suppose, if I have to connect to various Servers dynamically, I will have to
use a Dynamic Properties Task. Let us say
I first create a Connection, named "SourceSrv" using the "Microsoft OLE DB
Provider for SQLServer".

To change the connection info for "SourceSrv", I need to create a Dynamic
Properties Task ( I create one named
"DynamicSrv". In the Package Properties screen of DynamicSrv, I see the
following hierarchy :

LoadContracts==>Connections==>SourceSrv==>OLE DB Properties. (LoadContracts
is the Package name).

I see that there is Connection info at the SourceSrv level as well as "OLE
DB Properties" level. My question is where
do I specify the connection info or atleast what is the difference in
specifying the connection info at these two places.

I tried browsing the BOL, but I could not find more info.

Thanks,
rgn

They are the same, but for preference I set the connection level property,
and only use the provider (OLE-DB) level if it is not on the connection.


--
Darren Green
http://www.sqldts.com

"Gopinath Rajee" <gopinathr (AT) healthasyst (DOT) com> wrote