sql server dts: retrieve info from sysdtspackagelog for the currently running pack -- sql server dts

retrieve info from sysdtspackagelog for the currently running pack

LP
5/31/2005 4:34:07 PM

sql server dts:

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?

Re: retrieve info from sysdtspackagelog for the currently running pack

Darren Green
6/1/2005 12:00:00 AM

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

[quoted text, click to view]