DTS Transformation-Binging over empty fields from a text file

[prevost999]

I am attempting, through a DTS transformation, to bring delimited data from a text file into a SQL Server database. My problem is that I cannot bring "empty" fields over without getting the following error:

Insert error, column 2('tcit',DBTYPE_STR),status 10: Integrity violation; attempt to insert NULL data or data which violates contraints.

Now, when I go into design mode for the table I am inserting into, and set Allow Nulls to true, the data
comes over fine, but it sets every blank field to <NULL>.
But I do not want to populate every
blank field with a value of <NULL>. I want them to be truly blank or &quot;empty&quot; fields.(except for dates)

Is there anyway to achieve this through an ActiveX Script function or some other script in the transformation?

 

[prevost999]

A summarized version of this problem is this:

Through DTS, when transforming data from a text file to a sql table, how do I convert null values to blank or empty values.