| Matt Meleski 2004-12-29, 5:52 pm |
| I do not believe there is a property exposed to retrieve the
Sql Connection string from a Sql Send or Receive port.
If you are calling your Send port, before invoking your component,
your Select statement could pass back the database and server names as part
of your Solicit-Response (Send) port . Your statement would look something
like :
select
db_name() as DATABASENAME,
SERVERPROPERTY('servername') as SERVERNAME,
etc.
For XML Auto
The database and servername would then be passed down to your
component from your orchestration, and the connection string could be
constructed there.This works well if integrated security is used. If a Sql
Login is needed where a login and password are needed, then possibly using a
configuration file is
an option :
http://blogs.msdn.com/scottwoo/arch...1/28/63940.aspx
Matt.
"Alex Feinman" wrote:
> My orchestration is dynamically bound to a SQL send port. Inside the
> orchestration I need to invoke an external object passing a connection string
> to it. I need it to match the connection string used by the SQL Send port.
> How can I access it inside an expression? If that's not possible, does it
> mean that I will need a custom component?
|