conditional split expression

Question

I'm using a conditional split.

What ever the value is for provider (null, 1, 0) it needs to compare it to dest_provider. It's working for 1 and 2, but not for nulls.

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

---

LISA86

Answer 1

Hi Lisa,

(DT_BOOL)NULL part is invalid. And the use of NULL, too.

Keep using ISNULL.

I frankly fail to understand what you try to express, in my view the expression should begin like

(ISNULL(@[User::Provider])) ? NULL(DT_WSTR, 2 ) : @[User::Provider]

---

Arthur

MyBlog

Twitter

Answer 2

Hi LISA86,
Based on your description, I did some research, but I couldn’t understand why you convert Provider to Boolean in expression?

Could you post some details information about what results do you want to get in your destination with conditional split and whether the dest_provider and provider is in the same table? Then we could help you to achieve it better.

Regards,
Seif

Answer 3

I'm trying to do  this

if the source column is null then make it null if not make it the same column

Have to do it with a varchar and a Boolean data type

((

ISNULL(RS_NAME)? NULL(DT_WSTR,2):RS_NAME)!=(ISNULL(Dest_RS_NAME)? NULL(DT_WSTR,2):Dest_RS_NAME))

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

---

LISA86

Answer 4

If you are talking about the database null then NULL is null, there is nothing to do then on your end. No need to check But if the value is a textual NULL then check for text.

---

Arthur

MyBlog

Twitter

Answer 5

yes it's db null, in source tbl it's null in destionation tbl it's not, I want to make it a null. I want whatever is in the source tbl to be in destionation tbl.  The syntax I have is not working.

((

ISNULL(RS_NAME)? NULL(DT_WSTR,2):RS_NAME)!=(ISNULL(Dest_RS_NAME)? NULL(DT_WSTR,2):Dest_RS_NAME))

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

---

LISA86