error: failing rows exceeds max specified

[slybitz]

I have the erro below and am not sure what to do to resolve it. Can someone please guide me in the right direction. Thanks!!!

Step Error Description: The number of failing rows exceeds the maximum specified. (Microsoft Data Transformation Services (DTS) Data Pump (80020005): ActiveX Scripting Transform 'Customer Transform' encountered an invalid data value for 'QStore' destination column.)

Is there any way to increaser the # of failing rows specified? Where can I go to do that?

 

[JayKusch]

Open up your DTS package

Double-click the Transform Data Task that is blowing up.

choose the Options tab.

Set the "Max Error Count" to a desired value up to 999.

Thanks

J. Kusch

 

[slybitz]

Great it went through this time, still with an error, but nonetheless it went to my final calc. I appreciate that! Do you know anything about the error or explicitly a problem from within my ActiveX script?

 

[JayKusch]

From what I can read in the error, you are pull a value from a source that is not what the destination column 'QStore' is expecting ...

invalid data value for 'QStore'

Maybe a datatype mismatch....

Thanks

J. Kusch