SkipFetch results committed by another Transformation in same task -
10-21-2004
, 05:26 AM
Has anyone come across this problem?
I have been using SkipFetch to split up comma separated values in the
source field to create multiple rows in the destination.
When I click 'Test' from within the script editor there's no problems
but when I run the task 'live' ie: with other transformations I get
errors to do with global variables not having been reset.
I managed to narrow it down to a DTSTransformStat_OK statement in
another transformation which seemed to be committing the previous
transformations inserts and effectively ignoring the hold I placed on
the record. A counter wasn't reset and so the code crashed on the next
iteration.
Is there a simple explanation for this? Is it the case that I shouldn't
use more than one ActiveX script in any one task ie: bundle all the
transformations together?
Thanks
Dan |