Hey all - Quick question,
I'm trying to use DTS to move SQL server data to Oracle.
I select the table(s) I want to move, use the oracle oledb driver (i test connected/credentials successfully) and wait...process goes through without a hitch, but when I go to oracle and do a select * I've got nothing.
Seems like DTS is working the problem was it is putting quotations around the tablse...ie
"tablespacename"."tablename" is there any way to disable the quotations around the tables?? If i create the table with a script in oracle - it does the same thing.