Blanks as Nulls

[Horsegag9]

Hey All,

I am trying to import a text file into a blank database, creating the table in the process. This is all done using DTS.

How can I avoid blank fields being represented as "Null"? I would like to to stay blank on import, but no amount of configuring in DTS can stop this from happening. Anybody have any suggestions?

Thanks in advance.

 

[willir]

See the following post...
DTS Import Package

My approach is to process the data after importing it.

 

[nja5150]

Not sure this solves your problem...would an IF statement that returns what you want if the field is NULL work?