January 25, 2005 at 6:47 am
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
January 25, 2005 at 7:41 am
I am pretty sure that the problem is that when you switched to ActiveX you now need to EXPLICITLY set the rowcount per step (this was implicitly done with subpackaging).
You may need to research how to set this I know it is going to be something like DTSPackage.properties. Unfortunately, I don't have a DTS book handy...
Good Hunting!
AJ Ahrens
webmaster@kritter.net
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply