dbTalk Databases Forums  

Results for DTEXEC command

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


Discuss Results for DTEXEC command in the microsoft.public.sqlserver.dts forum.



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

Default Results for DTEXEC command - 09-24-2008 , 11:39 AM








I am executing a SSIS package from Management Studio using the DTEXEC
command in SQLSERVER 2005. The package is executed successfully.

But i am not able to find the following details in the execution result
pane.

How many records has been updated in each table? and
How many concurrent connections has been executed?

Do i need to change any settings in my package/Management studio to get
those results.

In SQLSERVER 2000, i am getting those results in Query Analyzer by
executing the package using the command DTSRUN.

Ex:-
DTSRun OnProgress: DTSStep_DTSDataPumpTask_14; 1000 Rows have been
transformed or copied.; PercentComplete = 0; ProgressCount = 1000

DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 2000 Rows have been
transformed or copied.; PercentComplete = 0; ProgressCount = 2000

DTSRun OnProgress: DTSStep_DTSDataPumpTask_14; 3000 Rows have been
transformed or copied.; PercentComplete = 0; ProgressCount = 3000

*** Sent via Developersdex http://www.developersdex.com ***

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.