I am a newbie, so please excuse my deficiency. I was successful connecting and importing data from Oracle to SQL Server 2008 R2 using SSIS for Oracle 10g, but when I try to add the Update command to my SQL statement I receive "ORA-00933 SQL Command
Not Properly Ended Microsoft OLE DB Provider for Oracle.
Here is what works perfectly;
SELECT name,contract,awdnumber,sponsorname FROM myoracletable WHERE audit_stamp >= substr(sysdate,1,10) and processed_flg='N'
However, when I add this additional info to the end of my statement I get the ORA-00933 error;
UPDATE myoracletable SET processed_flg='Y' WHERE processed_flg='N' and audit_stamp >= substr(sysdate,1,10)
My goal is to import records into SQL, then UPDATE the newly imported records in ORACLE, by changing the process_flg from N to Y. Can someone point me in the right direction, am I close? Any help would be greatly appreciated.