Results for DTEXEC command



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 ***
.

Relevant Pages

  • Re: Problems installing XP SP2!
    ... package source directory and make sure the that XPSPS2sms.exe file exists in ... in your SMS Program command line property. ... > Executing program as a script ... > OnOptionalExecutionRequests failed for program Automated upgrade from XP ...
    (microsoft.public.sms.admin)
  • Re: Access while running DTS package using stored procedure
    ... The permissions when executing xp_cmdshell can be different depending on who ... which the SQL Server service is running. ... > I wrote a DTS Package that can take the data from a .txt file residing ... > Declare @RunDTS as varchar ...
    (microsoft.public.sqlserver.dts)
  • QUESTION: shared libraries
    ... how would I create a package easy-to-install for a new user? ... we could use a script to install the package. ... I have seen some scripts executing from a ... Gouvernement du Canada / Government of Canada ...
    (comp.os.linux.development.apps)
  • QUESTION: shared libraries
    ... how would I create a package easy-to-install for a new user? ... we could use a script to install the package. ... takes root privileges to do so. ... I have seen some scripts executing from a ...
    (alt.os.linux.redhat)
  • QUESTION: shared libraries
    ... how would I create a package easy-to-install for a new user? ... we could use a script to install the package. ... takes root privileges to do so. ... I have seen some scripts executing from a ...
    (comp.os.linux.development.system)
Quantcast