Post reply

SSIS error with using the Conditional Split

  • April 29, 2014 at 1:53 pm

    #292844

    Hi All,

    I am using the Conditional Split and in the condition box I am trying to compare two columns to test if they are equal or not. Here is an example of what I am doing:

    ((ISNULL(Lkp_DATEENROLLED) ? "1901/01/01" : Lkp_DATEENROLLED) != (ISNULL(DATEENROLLED) ? "1901/01/01" : DATEENROLLED))

    I am getting the error and i know it's because of the datatypes. Instead of using "1901/01/01" as if it were a string field, what can i use for a datetime field?

    Please let me know.

    Thanks

  • April 29, 2014 at 2:59 pm

    #1709643

    try this:

    ((ISNULL(Lkp_DATEENROLLED) ? (DT_DBDATE)"1901/01/01" : Lkp_DATEENROLLED)

    !=

    (ISNULL(DATEENROLLED) ? (DT_DBDATE)"1901/01/01" : DATEENROLLED))

    Alex S

  • April 29, 2014 at 3:29 pm

    #1709648

    Thanks for the response. I tried this example and it works.

    Thanks again.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply