Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2007-03-20 : 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?" |
|
|
nosepicker
Constraint Violating Yak Guru
366 Posts |
Posted - 2007-03-20 : 21:10:54
|
| It would probably be easier and faster if you import the raw data into a staging table first. Then you can use SQL statements to do your conversions. Trying to do conversions during the import can be messy. |
 |
|
|
|
|
|
Importing data using DTS