DSXchange

Hi Folks,

I am using sybase stage as source and sequential file as target. I am inserting one user defined query in the sybase stage. When executing the job, I am getting the following error.


Failure during execution of operator logic.

Fatal: Attempt to get target table info from sp_tables failed.

But when i run the query in sybase it showing the data.

Could anybody suggest me on this.

Regards,
Sateesh.M

Hi ,

Regarding the above topic i had splitted the query and i ran now.Now i am getting the following warning.

Sybase Server warning 11055 (severity 16) from stored procedure 'sp_tables', line 191: Query contains an illegal outer-join request.

Any suggestions would be great.

Thanks in advance.

Regards,
Sateesh.M

Lose the illegal outer-join part of your query.