How to Handle blank data in Date columun on ssis

• duggiralaamruth

  Newbie

  Points: 7

  More actions

  June 28, 2012 at 11:47 pm

  #271916

  I am importing data from Flatfile to Sql server table .

  Inbound colunmsn :

  ID,name,terminationdate

  1,11,NULL

  2,12,06.28.2012

  3,13,

  3rd record is having blank in Terminationdate fiels which is string.

  I am inserting into a tbale where terminationdate is Datetime.

  How to handle the above scenarios...

• Koen Verbeeck

  SSC Guru

  Points: 259197

  More actions

  June 29, 2012 at 12:40 am

  #1506959

  You'll need to use a derived column to convert the strings to an actual datetime value.

  You can check first if there string value is blank and if it is, replace it with a dummy datetime, such as 1900-0-0 for example.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP