|
Posted by Freddie on 01/12/06 21:47
Hello Everyone:
I am loading a text file onto a table. One field is a text and the
field in my table is a numeric.
Here's a sample of my code....i get (type mismatch) error....can
someone help me.
sample data to be loaded (" ^876504 ") text
sample date loaded (87654) numeric
Function Main()
DTSDestination("test") = CInt(Mid(DTSSource("Col006"),2 , 6))
Main = DTSTransformStat_OK
End Function
Thank you!!
Freddie
Navigation:
[Reply to this message]
|