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.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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment