Capture Execution Progress -- sql server dts

Gary
5/13/2004 6:19:11 PM

Hi All

How would I go about capturing the outut that is
displayed on the Execution progress form that is
displayed when a DTS Package is executed interactivley.
I would like to capture the details that are shown
including the step that is running and the number of
records processed as I would like to create a log file
that displays this info ie.

Step 1
11:16:23 1000 Records
11:16:25 2000 Records
Step2
11:16:30 1000 Records
11:16:40 2000 Records...etc

Allan Mitchell
5/14/2004 6:48:58 AM

You will need to use a development language such as VB and use Events.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;321525

http://support.microsoft.com/default.aspx?scid=kb;en-us;319985

http://support.microsoft.com/default.aspx?scid=kb;EN-US;221193

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

[quoted text, click to view]

sql server dts : Capture Execution Progress