Hi Team ,
I have a DTS package which has failed with the below reason
Step Error Description:Column name '((((NVL(TITLE,'')||' ')||NVL(NAME_1,''))||' ')||NVL(SURNAME,' was not found.
Step Error code: 80042008
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:0
But when I manually execute the query , this is working as expected .
Can any one guide what the issue is