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 |
|
Lethanta
Starting Member
1 Post |
 Posted - 2010-02-24 : 14:01:00
|
| Hi,New to SQL Server 2005, and didn't experience any such problems with 2000.When importing from a tab-delimited flat file, is there a way to instruct the SSIS Import/Export Wizard to convert blanks in columns with numeric data types to NULL rather than 0? If not, how should I go about importing this data?Thanks |
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2010-02-24 : 14:42:00
|
| There is a "KeepNulls" porperty (under properties) which is set to False by default...I think you can change that to True and try your import. |
 |
|
|
|
|
|
Importing Numeric Columns with NULL values