Here is what I found.

db2 - account_no - data type - decimal

sql - account_no - data type - decimal

in lookup, i have to use both columns but by default its...

Thanks but its a part of bit complex already existing package and I have to use it this way only. I tried to create SP for the update statement and...

IF TOTAL_BILL_AMT_PROD = NULL THEN NULL ELSE (TOTAL_BILL_AMT - TOTAL_BILL_AMT_PRD = O then 0 Else 1 )

ISNULL(TOTAL_BILL_AMT_PRD) == ""? NULL(DT_STR, 4, 1252) : ((DT_NUMERIC,10,2)TOTAL_BILL_AMT_PRD - DT_NUMERIC,10,2)TOTAL_BILL_AMT == 0 ? 1...

Thanks it worked finally. Really appreciate it.

(DT_NUMERIC,10,2)TOTAL_BILL_AMT - (DT_NUMERIC,10,2)TOTAL_BILL_AMT_PRD == 0 ? 0 : 1

Thanks. Datatypes for both are decimal(10,2)

if the difference =0 then insert 1 (bit datatype) or 0

Thanks. It's inside Data Flow task and I have hard time compiling this IF condition.

IF TOTAL_BILL_AMT - TOTAL_BILL_AMT_PRD = 0 then 0 Else 1.

Here is  what I wrote but error,...

• This reply was modified 5 years, 6 months ago by  dallas13.

Thanks a lot. I had a named instance so specifying a server name has resolved the issue for me. Thanks a lot.

Thanks John. When I did it with cmd line, it was giving me very different error,
I tried with -T integrated security. That account is sysadmin on sql.
I...

Thanks John as I said I ran it from sqlcmd line tool.

Thanks a lot everyone for helping.

Also Thanks again Lynn.
When I tried,
If @searchStr > ''
After that I can successfully run it from SP.
Can you also please give me some...

Hello Lynn Pettis
Thanks but I've already tried the test...

YES sgmunson and that sql is very well working. its just not...

Thank you sir.
In my case @searchstring is also NULL and it should not go inside the IF condition and just execute @sSQL which is not happening here.

Thanks a lot Everyone.
Special Thanks to Eddie. It was great to know before implementing this.