Executing DTS Package
Use this dialog box to view the execution progress of the Data Transformation Services (DTS) package overall, as well as the execution status of the individual tasks composing the package.
To display error information about a task, double-click the task that did not execute correctly.
View the name of the task that executes in the step.
View the progress of the executing step, and whether the step completed successfully or failed. For tasks that report the number of rows processed (shown in parentheses), the number indicates the total number of rows read from the source, not the number of rows that were successfully processed.