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.
Any insight into this?Did you get any errors?
How much data?
I would bcp the data out and use SQLLOader on the Oracle side...
But that's just me...|||Does DTS automatically commit the inserts?|||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.|||Answered my own question. Thanks anyway!
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment