question

Chris 2 avatar image
Chris 2 asked

SSIS sql task to Oracle

Hi, On Windows 2008 serer and MS SQL 2012, a SQL task to Oracle with IS NULL checking does not work. IS NULL checking works fine when testing in Oracle SQLDeveloper. Is there way around? Thanks. Chris
sql 2012
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
nikhil_satam avatar image
nikhil_satam answered
Hey Chris, If you are writing a T-SQL query, check the syntax ISNULL(column_name, character to replace with) For Ex: ISNULL(Emp_Address, 'ZZ') If you are writing a Oracle query, use NVL function NVL(column_name, character to replace with) Ex: NVL(Emp_Address, 'ZZ')
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.