retrieving an instance name

In an DTS ActiveX I need to open an ADODB connection whose Data Source shoud
be the SQLServer instance where the DTS is located.
How can I retrive the instance name?
Thnx
Kyky
Hi
Not that I am aware of. DTS Packages can be run outside the scope of the SQL
Server, or be compiled into VB6 projects.
Regards
Mike
"Kyky" wrote:

> In an DTS ActiveX I need to open an ADODB connection whose Data Source shoud
> be the SQLServer instance where the DTS is located.
> How can I retrive the instance name?
> Thnx
> Kyky
>
>
|||You can add a T-SQL to the DTS package and select @.@.servername to get the
instance.. .map the return value to a global variable and use it anywhere...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Kyky" <kyky_az@.yahoo.it> wrote in message
news:e%230BNtZGFHA.3928@.TK2MSFTNGP09.phx.gbl...
> In an DTS ActiveX I need to open an ADODB connection whose Data Source
> shoud
> be the SQLServer instance where the DTS is located.
> How can I retrive the instance name?
> Thnx
> Kyky
>

retrieving an instance name

In an DTS ActiveX I need to open an ADODB connection whose Data Source shoud
be the SQLServer instance where the DTS is located.
How can I retrive the instance name?
Thnx
KykyHi
Not that I am aware of. DTS Packages can be run outside the scope of the SQL
Server, or be compiled into VB6 projects.
Regards
Mike
"Kyky" wrote:

> In an DTS ActiveX I need to open an ADODB connection whose Data Source sho
ud
> be the SQLServer instance where the DTS is located.
> How can I retrive the instance name?
> Thnx
> Kyky
>
>|||You can add a T-SQL to the DTS package and select @.@.servername to get the
instance.. .map the return value to a global variable and use it anywhere...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Kyky" <kyky_az@.yahoo.it> wrote in message
news:e%230BNtZGFHA.3928@.TK2MSFTNGP09.phx.gbl...
> In an DTS ActiveX I need to open an ADODB connection whose Data Source
> shoud
> be the SQLServer instance where the DTS is located.
> How can I retrive the instance name?
> Thnx
> Kyky
>