Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2004
    Posts
    5

    Unanswered: DTS no error, but no data either...

    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?

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    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....
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Does DTS automatically commit the inserts?

  4. #4
    Join Date
    Jun 2004
    Posts
    5
    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.

  5. #5
    Join Date
    Jun 2004
    Posts
    5
    Answered my own question. Thanks anyway!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •