I am getting the following error, Invalid procedure call or argument:
'DTSDestination'

I have the following code,

If DTSSource("Complete") <> "" Then
DTSDestination("Amount") = DTSSource("Complete")
DTSDestination("Complete") = 1
Else
DTSDestination("Complete") = 0
End If

Main = DTSTransformStat_OK

It is erroring on the DTSDestination("Amount").Value = DTSSource("Complete")
line. I have 4 of these type columns, 3 of them are working fine and this
one is giving me problems. I even copied/pasted the code from the other
transforms, and then they error out too. I even deleted the transformation
and re-created it, still the same error.

What am I doing wrong?

Thanks,
Drew

Figured it out... Since my conditional was transforming 2 columns, I had to
add the Amount column to the Destination Columns tab.

Everything works fine now.

Thanks,
Drew

"Drew" <drew.laing (AT) NOswvtc (DOT) dmhmrsas.virginia.SPMgov> wrote