|
AskSQLTeam
Ask SQLTeam Question
USA
0 Posts |
 Posted - 03/20/2007 : 09:50:24
|
Howard writes "I have raw data in a flat file that has blanks that I'd like to be considered NULLs in the SQL server database.
I am hoping that there is a very simple way to do this.
I do not want to check each field for a blank first.
A similar problem is that sometimes a numeric field might have bad data, say a character somewhere. Is there a simple way to convert the bad data into a NULL automatically?" |
|
Importing data using DTS
