SSIS -Conditional Filter with Bit datatype


  • Data - from table (58 columns), in this table 4 columns will use in conditional filter.

    1 column - bit data type(Color_Ind)

    1 column - bit data type(Type_ind)

    2 columns - varchar data type(Region,State)

    process steps 1) OLE DB connection to extract all data

    2) use Data Conversion to convert bit type columns into string data type.

    3) use conditional filter to filter the data into 5 different category.

    Probelm:- - If I use color_ind and Type_ind it will not create my desired out put.but If I use it without this columns and only use Region and state it will create my desired output.

    Could you please tell me how to use bit data type into condtional filter in SSIS?

    Appreciate your help.


    Tuesday, October 09, 2012 7:25 PM


All replies

  • what are your condition's expressions in conditional split?
    and what is your desired output?

    Tuesday, October 09, 2012 7:31 PM
  • I used conditions in conditional filter as

    Color_ind ="1"&& Region="29" && state="5" --> Type A

    Type Ind="1"&& region="14" --> Type B

    Color_ind ="1"&& Region="22" && state="19" --> Type C

    Color_ind ="1"&& Region="33" && state="15" --> Type D

    so I will work fine in sql server but when I take all the conditions and placed into conditional filter it will creates the blank output and If Removes Color_id and Type_ID  it will create by desired out put.

    Tuesday, October 09, 2012 7:38 PM
  • Put a data viewer after the data conversion transformation to check what values you get in the converted column. It might be a case of improper conversions leading to the conditional split not evaluating correctly.

    Tuesday, October 09, 2012 7:40 PM
  • For comparing boolean values you can do this:

    Color_ind=True && Region ....

    This works if data type of Color_ind is Boolean in SSIS

    • Marked as answer by myworld343 Tuesday, October 09, 2012 7:53 PM
    Tuesday, October 09, 2012 7:44 PM
  • It's not working...:(
    Tuesday, October 09, 2012 7:51 PM
  • Sorry Its working...Thanks
    Tuesday, October 09, 2012 7:53 PM