Hi,

I have a small problem with tranformation.
The code is:

Function Main()
a = DTSSource("ConfQuantity").value
if DTSSource("CancelledConfirmationCounter") = 0 then
DTSDestination("ConfQuantity")=DTSSource("ConfQuan tity")
else
DTSDestination("ConfQuantity")= a *(-1)
end if
Main = DTSTransformStat_OK
End Function

So as you can see it's very simple code which is reversing number when
source is different then 0.
But it's not working. I don't know what I'm doing wrong.
Error shows up when DTSDestination("ConfQuantity")= a *(-1) line is
being executed.

Thanks in advance.

Maciej Chojnacki

Hello MacChojnacki (AT) googlemail (DOT) com,

What's the error?
Bye

Error is: The number of failing rows exceeds the maximum specified.
Type mismatch error.

I noticed that this kind of error shows up on every operation with
numbers eg multiply,divide.
So when want to get :
DTSDestination("ConfProductionLaborTime") =
DTSSource("ConfProductionLaborTime")/60
I always get this error.

Please help me.

Hello MacChojnacki (AT) googlemail (DOT) com,

So it' s type-mismatch;
Probaly there are some records in your source object where DTSSource("ConfProductionLaborTime")
has a value not numerical (or not interpreted as numerical) so not divisible
by 60.
What are the Regional Settings of the machine on which DTS are running ?
Consider this example: if your regional setting are English the string
",39" is not considered numerical.
Bye