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.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 How to manage NULL value from text files

Author  Topic 

olibara
Yak Posting Veteran

94 Posts

Posted - 2012-02-22 : 11:30:05
Hello

I'm trying to use the Import / Export wizard to import about 300.000 rows in an Sql Server 2008 Table
The source is a tab deklimited text file

I have same dates and integer with Empty value in the text file
All colums in the DB Table are NULL Allowed

However I get a Conversion error for those Empty fields !

What can I do
Thank for any help
   

- Advertisement -