convert date columns in flat souce file to date

• sqlfriend

  SSC Guru

  Points: 52794

  More actions

  December 8, 2011 at 12:34 pm

  #150695

  I have a flat source with a column format like date, format like 10/23/2011

  it will be imported to SQL table with data type date.

  In the flat source connection manager editor screen, I go to advance, set it up to use dt_dbdate.

  But I got an error when running the package, I got an error to convert the column.

  I guess it is probably there are a lot of blank values or null values in the flat source file, so what can I do to make the import to destination to if it is empty or null, make it null, other vise, convert it to date.

  Thanks.

• Koen Verbeeck

  SSC Guru

  Points: 259197

  More actions

  December 9, 2011 at 7:29 am

  #1419360

  You are getting conversion errors because your date format probably isn't correct.

  Check out the following topic:

  http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/65e1c7d2-5410-48d9-9bb1-964ea124d0d1/

  You can easily check for NULL values using the ISNULL function.

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