I'm trying to run an update query in a sql DTS package. I created the the 2 connections, SQL-Oracle in the package design and an ODBC connection between the two boxes. Just a basic update
"update owner.table"---Oracle table
set owner.table.column = table.column--sql-Table
from sql table
where oracle-owner.table.column = sqltable.column
end
Where am I going wrong?
various errors:
improperly ended sql statement
table doesn't exist etc.
Thanks