conditional split expression with boolean data type

Question

 Expression is in conditional split. I need the values in Provider field to change in Dest_Provider.  If it's a 1,0 or null.  Following statement works if it's 1 or 0, but not for null.  So, if Provider is null then dest_provider is null, if Provider = 0 then dest_provider

= 0 and  if Provider = 1 then dest_provider = 1.  Thanks

((ISNULL((DT_BOOL)Provider) ? (DT_BOOL)0 : (DT_BOOL)Provider) != (ISNULL((DT_BOOL)Dest_Provider) ? (DT_BOOL)0 : (DT_BOOL)Dest_Provider))

---

LISA86

Answer 1

Can you state what this conditional split is suppose to do?  The way that a conditional split works is that you have a series of Boolean expressions that define outputs. If a Boolean expression returns true for a row, then the row will be output for that row.

---

Russel Loski, MCSE Data Platform/Business Intelligence Twitter: @sqlmovers; blog: www.sqlmovers.com

Answer 2

Hi Lisa.

Changing values has to belong to the Derived Column Transofrmation

Furthermore (DT_BOOL)0 or (DT_BOOL)Provider do not make sense to me.

---

Arthur

MyBlog

Twitter

Answer 3

Hi LISA86,

According to your description, I think using a Derived Column Transofrmation or using a Copy Column Transofrmation is better than using Conditional Split Transofrmation in SSIS.

If you choose Derived Column Transofrmation Reference the below.

If you have any other questions, please feel free to post.

Regards,
Seif Wang