views:

270

answers:

2

I import data from a TSV file with SQL Server 2008.

null is replaced by 0 when I confirm a table after import with integer column.

How to import as null, please Help me!!

+2  A: 

After comment:

  • Using SSIS "Bulk insert" task, options page, "Keep nulls" = true This is what the import wizard uses: but you'll have to save and edit it first because I see no option in my SSMS 2005 wizard.
gbn
how to set this value?? options tab from tools menu??
Aditya
A: 

This can be set in the OLE DB Destination editor....there is a 'Keep nulls' option.

James