DSXchange

Hey Craig,
Noe the job is running. But I think it is in a deadlock. It doesn't get finished. Delete is happening, But it is stopping at the INSERT statement. (From director)

The delete query I am using is delete from tablename where column1=20 insert query is INSERT INTO Tablename(column1,column2,column3,column4,column5) VALUES (:1,:2,:3,:4,:5) I am using autogenerated query using "Inser rows without clearing" Craig can I sedn the job snapshot to your personal...

I tried the above method, ie 2 links to the same Oracle stage. But it is givin illegal variable name/number error. CopyOfupdatetest..Oracle_OCI_0: ORA-01036: illegal variable name/number.
Any help regarding this will be appreciated.

My requirement is slightly different. I dont want to delete all records. I want to delete some records based on some criteria.

My requirement is , 1. Want to delete all records in a table. 2. Insert new records from a flat file. 3. If the insert fails rool back to the previous state. (Table with old records) I am using an oracle stage for inserting new rows. In the before tab of SQL in OCI stage, I am specifying the delete ...

I want to generate an XML with the following specifications. 1. Header - One/message(STORE). 2. Payload - Multiple employee details. ie, Multiple employees will be there for STORE So I am making all the payload field as keys and Header field not. That is working fine. Now I want to repeat a particul...