I am trying to transform a column with DTS as it is coming. Basically I have a source field that was supposed to be numeric but someone put in charaters. I need to convert these fileds to a numberic value so the will go into my smallint destination field.
So the source fields contain tha actual value 'XXXX' and I need to convert it to 0000.
This is what I have written but I get a syntax error on line 1 when I run this. Any help would be greatly apprecaited.

Function Main()

If DTSSource("dma&#34 = 'XXXX' then
DTSDestination("DMA&#34 = 0000
Else
DTSDestination("DMA&#34 = DTSSource("dma&#34
End if

Main = DTSTransformStat_OK
End Function