Using case logic in SSIS

• tmmutsetse

  Hall of Fame

  Points: 3669

  More actions

  August 7, 2018 at 7:07 am

  #362004

  HI experts,

  I have a CSV column "Withdrawal" with either TRUE or FALSE as values. The destination SQL table has a bit by design which means if its true then 1 or 0.Please help how can i apply this logic inside my package?

  Many thanks

  Regards

  T

• RonKyle

  SSC-Dedicated

  Points: 31565

  More actions

  August 7, 2018 at 7:35 am

  #2000592

  I've had to deal with this before:

  CASE Withdrawal WHEN TRUE THEN 1 ELSE 0 END AS Column_Name

• drew.allen

  SSC Guru

  Points: 77009

  More actions

  August 7, 2018 at 7:49 am

  #2000599

  I don't know about SSIS, but SQL will automatically convert TRUE to 1 and FALSE to 0 when assigned to a bit field.

  Drew

  J. Drew Allen
  Business Intelligence Analyst
  Philadelphia, PA

• JustMarie

  SSCertifiable

  Points: 7771

  More actions

  August 14, 2018 at 1:49 pm

  #2001749

  If you're doing this during a data flow you can use the Derived Column transformation. That will also let you get it into the correct data type downstream.

• RonKyle

  SSC-Dedicated

  Points: 31565

  More actions

  August 14, 2018 at 1:57 pm

  #2001751

  I don't know about SSIS

  SSIS is very picky.  Just about, if not everything, has to be stated explicitly.  I'm certain I had to do the CASE statement above to bring the data from PostgreSQL.