(DT_I4)"abc"==(DT_I4)"abc" ? 1 : 0 in ssis giving NULL

Question

It is giving NULL . Can i know the exact reason and how can i rectify it

Answer 1

Hi @Chakri. N ,

May I know what the value of the column "abc" so that we could do some local test.

I did some test, if the column contains null value, it will return NULL like shown below.

Answer 2

It is giving NULL

What else do you expect for a formula like

(DT_I4)"abc"==(DT_I4)"abc" ? 1 : 0 in ssis giving NULL

Converting a string literal "abc" to DT_I4 = integer 4 byte will always fail.

Answer 3

Hi @Chakri. N ,

DT_I4---A four-byte, signed integer.

"abc" is a string in SSIS might be DT_WSTR.

You cannot convert DT_WSTR to DT_I4. It will thrown error like below.

If you configured the error output to ignore the failure, it will return NULL in the result.

I'd like suggest that you may add a new Derived Column to replace NULL to 0 as you need.

REPLACENULL([New Column 1],0)  

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.