Help with DTS - MSSQL to Oracle

[MarkWilliamson]

am using the MSSQL 7.0 DTS Wizard to copy a MSSQL Table to Oracle - the process copies approx. 10000 records ( there are 500000 ) and it bombs out with the error below. I thought it might be a tablespace issue in Oracle but it looks ok to me.

Thanks in advance to all who reply !!!


The execution of the following DTS Package succeeded:

Package Name: SQL2Oracle - Daily Activity
Package Description: DTS package description
Package ID: {C59E0124-560C-485E-9FD6-671E77629D89}
Package Version: {68728DD2-5A6A-4F7D-A56B-3AE6AFD05248}
Package Execution Lineage: {AD3E82DB-0526-4A1F-9B3D-38F2346FD505}
Executed On: ORACLE_TEST_SVR
Executed By: Oracle_Test
Execution Started: 2/17/04 8:10:40 AM
Execution Completed: 2/17/04 8:11:46 AM

Package Steps execution information:

Step 'Copy Data from DailyActivity to "HZNREPORTING"."DAILYACTIVITY" Step' failed

Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:Need to run the object to perform this operation
(Microsoft Data Transformation Services (DTS) Data Pump (80040005): Code execution exception: EXCEPTION_ACCESS_VIOLATION)
Step Error code: 80040005
Step Error Help File:sqldts.hlp
Step Error Help Context ID:700

 

[JayKusch]

Have your tried the reverse operation yet. In that I mean, if you were EXPORTING from SS to Oracle, try IMPORTING from Oracle.

Thanks

J. Kusch