expression in ssis

Hi,
i have stg_table

sin    lcode
123    01
123    02
123   03

join it with d_code
d_code  desc               d_code_id
-99         unknown         -99
01           usa                   2
02           ca                    3

when i join them using left outer

i get results like below

sin       lcode  d_code_id
123    01            2
123    02            3
123   03            null


i want null to be -99 i try to do in expression isnull(d_code_id) =-99 it is not liking it
sam2929Asked:
Who is Participating?
 
ValentinoVBI ConsultantCommented:
In case you were wondering, syntax for ISNULL is similar: ISNULL(d_code_id, -99)
0
 
ValentinoVBI ConsultantCommented:
You could use this: COALESCE(d_code_id, -99)

COALESCE (Transact-SQL)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.