none
SSIS:Boolean Conversion, only getting NULL Values

    Question

  • i have a Column which i am Converting the following way:

    as you can see, i am taking a column (that was of the type nvarchar(255) before) and turning it into a Bool, since all of the Values are eather "Ja" or "Nein" (German for "Yes" and "No")

    The Package runs completely flawless, and i even started cheering thinking i had found the solution. But in the Table I am only getting NULL Values?

    How is this explanable ? does anybody know what i am doing wrong? Thanks a lot in advance (NOTE: The Values i am using come from a SharePoint List Source that after the conversion Process are inserted into an OLE DB).

    Saturday, November 09, 2013 5:40 PM

Answers

  • LOWER(column) == "ja" ?  TRUE  :  FALSE 

    This would help you to remove case sensitivity from comparing. However, this doesn't explain the reason for getting null. Can you post couple of rows so that i can see by replicating the same scenario. 

    • Marked as answer by gbobj Sunday, November 10, 2013 12:00 PM
    Saturday, November 09, 2013 8:03 PM

All replies

  • LOWER(column) == "ja" ?  TRUE  :  FALSE 

    This would help you to remove case sensitivity from comparing. However, this doesn't explain the reason for getting null. Can you post couple of rows so that i can see by replicating the same scenario. 

    • Marked as answer by gbobj Sunday, November 10, 2013 12:00 PM
    Saturday, November 09, 2013 8:03 PM
  • Here you go Sir:

    This is how the Values look like,

    I've tried LOWER but it didn't work

    Sunday, November 10, 2013 11:45 AM
  • Thanks for your help. I have just found the fix to my Problem,

    wrongly assigned the Columns on the DB Destination!

    Thanks a lot for your help

    Sunday, November 10, 2013 12:01 PM