dbTalk Databases Forums  

Capture Execution Progress

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Capture Execution Progress in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Gary
 
Posts: n/a

Default Capture Execution Progress - 05-13-2004 , 08:19 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

Thanks

Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: Capture Execution Progress - 05-14-2004 , 12:48 AM






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

http://support.microsoft.com/default...b;EN-US;321525

http://support.microsoft.com/default...b;en-us;319985

http://support.microsoft.com/default...b;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


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

Quote:
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

Thanks



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.