I have an ActiveX Script Task that is the last step in a Package which
inserts an "audit log" record in a table. But the ConnectionString to insert
the log record is a fixed string. I would rather use the global variable to
set the connectionString, or re-use an existing connection. Does anyone know
how to do this?

Thanks,

Michael

Why bother?

Have an ExecuteSQL task that points to the correct place (Configurable) and
you can then insert the statement through a Global Variable as well.

Global Variables and SQL statements in DTS
(http://www.sqldts.com/default.aspx?205)

Connections
(http://www.sqldts.com/default.aspx?101)

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


"Snake" <Snake (AT) discussions (DOT) microsoft.com> wrote