Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003

    Unanswered: Data Transformation Services

    When I use the DTS to export data from SQL Server to Oracle 8i, I have no trouble doing it by exporting a whole table. However, if I try to export to Oracle using an SQL query, the table in Oracle gets created, but the table doesn't get populated by the data in my query. I get an ok on the creation of the table, but on transferring of data, I get an error that the table in Oracle doesn't exist. Any ideas? Thanks.

  2. #2
    Join Date
    Oct 2003
    Is the creation of the table and pumping of data separate tasks?
    If so can you execute them one at a time in the DTS package designer?

    I don't know if there is a good way of debugging DTS packages, if anyone knows of it I would appreciate to know how too.

Posting Permissions

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