Hello All,

I'm auditing my ETL processes and I want to get the following info about the
currently running dts package from sysdtspackagelog.

select [name], [description], [id], [versionid], [lineagefull], [starttime]
from sysdtspackagelog

Anyone else need this info during execution?

I thought about passing the package name and starttime dateadd(mi, -1,
GetDate()) but that does not seem iron clad enough. Any ideas?

Turn on "Show lineage variables as source columns" from the Advanced tab of
the package properties. You get new columns in the DataPump, but also
normally get two new global variables. You can then use the lineage guid to
query the table. This is the current execution instance id.


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


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