SQL error

[ds1user1]

Hi all,

Any idea why i am getting this error.

Code: Select all

Initial_Extract,0: Warning: CopyOfJOB1.Initial_Extract: Sybase Server warning 2762 (severity 16): The 'CREATE TABLE' command is not allowed within a multi-statement transaction in the 'tempdb' database. 

I am using sybase OCI stage to extract the data and written a big SQL using some temp table but at the end i am dropping these tables.I dont know y i am getting this error message.

Any help is appreciated
Thanks

[kcbland]

Because a SQL statement is not the same as a DML statement. Only put SQL in the user-defined area. If you need to do DML, use before/after SQL with an anonymous block stored procedure, do your drops outside a transformation job, or switch to using a stored procedure.