Multiple Null tabs issue

• rakeshkrishnan85

  Newbie

  Points: 5

  More actions

  June 4, 2008 at 2:14 am

  #129385

  Hi All,

  I encountered the following problem while loading data from a TAB-DELIMITED flat file into a SQL Server table.

  I have a table with two columns(Both are of type numeric(18,0). Please note that NULL value inserts have been enabled in the table definition).

  I am trying to import the following two rows into it from the flat file.

  columnA columnB

  1 4

  6

  As you can see, the value is NULL for columnB in the second row.

  When this flat file is imported using SSIS(Import/Export Wizard), the data gets populated in the following manner:

  columnA columnB

  1 4

  6 6

  As you can see, for the second record, the value of columnA has been copied to columnB.

  I am facing this issue only while importing NULL values into a column of type numeric(or int or other similar types).

  Any idea why this issue is surfacing?

  Thanks in advance!!

• KenpoDBA

  SSCrazy Eights

  Points: 9811

  More actions

  June 4, 2008 at 9:06 am

  #824242

  Did you put a check on 'keep nulls'?

  Watch my free SQL Server Tutorials at:
  http://MidnightDBA.com
  Blog Author of:
  DBA Rant – http://www.MidnightDBA.com/DBARant

  Minion Maintenance is FREE: