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

DTS is a basically COM object, and as such not related to a SQL Server. You
can store DTS inside a SQL server table, but then you can store an image in
a table, and once it has been retrieved there is no link back to the SQL it
was stored in, same applies to DTS. DTS packages are not running inside SQL
server nor are they regular SQL objects.

You would need to pass in the instance name before you execute the package.

For example I run packages via SQL Agent jobs, and wish to read some config
data stored in a SQL table. I do this by manually setting the job command to
be a DTSRUN command which includes /A to set a global variable. The package
now knows where to get its config from, and whilst in practice this is
always the same as the instance where it is stored, and where it is called
from via SQL Agent, it does not need to be.

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


"Kyky" <kyky_az (AT) yahoo (DOT) it> wrote