I have a flat file with 3 million records.One of the field is numeric. What I
am trying to do is transform the flat file data into sql table.The DTS
Package fails. The Reason it fails is that one of the Numeric Field has Blank
value in it.what do I need to do within a DTS Package so it converts the
blank into 0 and imports the flat file data into sql table.
--
sanjig

hi munny,

You must go to Transform Data Task properties->Transformations and then
modify the line between source and destination as ActiveX Script and using
VBScript do a few lines in order to solve this feature, creating a
conditional structure with IF.

I suppose that that numeric field is empty from time to time (or four or
five times along the file) not in all cases or not?
Best regards,

"munny" wrote: