SSIS 2008 : How to use IsDate on Derived Column transformation

• chris.asaipillai 94746

  SSChasing Mays

  Points: 628

  More actions

  January 26, 2016 at 8:15 am

  #307922

  Hi

  I am importing data from an Ms Excel spreadsheet. One of the columns should be in a date format...but it sometimes is the

  format 'Indefinite'

  Therefore I am trying to created a Derived Column transformation as follows:

  ([AOC End Date] == "Indefinite" ? "01/12/2099": [AOC End Date])

  Ie if [AOC End Date] is not equal to Indefinate then set it to 01/12/2099 else set it as [AOC End Date]

  What am I doing wrong here?

• JustMarie

  SSCertifiable

  Points: 7771

  More actions

  January 26, 2016 at 3:06 pm

  #1854571

  What error(s) are you getting? Right now I don't see anything wrong with your syntax.

  Is the data flow expecting that data type to be a date and you're pushing a string?

  We need more information to help you.