I have a master package that calls several subpackages. The subpackages largely copy tables from one database to another. In the DTS GUI I defined the subpackage as a subpackage. When I would run the packages I'd receive log data as follows for each table:
Step 'step32' succeeded
Step Execution Started: 11/8/2004 11:52:12 AM
Step Execution Completed: 11/8/2004 11:52:13 AM
Total Step Execution Time: 0.141 seconds
Progress count in Step: 49
Nice to have the count of rows included per table for possible diagnostics.
Recently I received a request that caused me to switch to executing the subpackages via an ActiveX script in the master package. After this change the row progress count always shows 0 as follows:
Step 'step32' succeeded
Step Execution Started: 1/18/2005 10:20:08 AM
Step Execution Completed: 1/18/2005 10:20:08 AM
Total Step Execution Time: 0.203 seconds
Progress count in Step: 0
The packages function correctly....but no row count. I did remove the FailOnError property when I switched to the ActiveX script but did not expect that to impact the row count.
Any ideas what might be going on here?
Thanks, Mark
Best Regards,
Mark Tierney