Unanswered: DTS Error - need to run the object to perform this operation Exception_access_violati
I am experiencing problems when trying to export data from SQL Server 2000 to an Oracle 9i.
SQL Server: Microsoft SQL Server 2000 - 8.00.760 (Intel X86) - Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 1)
Oracle9i Database version 188.8.131.52
Most of the tables are transferring fine (created and populated with data), but there are a few that is causing an exception access violation every time I run it. Not only when I run the package, but also when I try to export only this table.
1. Create table in Oracle Schema using DTS ( I have also tried to create the table in Oracle first and only transfer data)
2. Transfer data from SQL Server to Oracle.
There is one table I am experiencing problems with. There is no problem creating the table on the oracle database, but it fails when DTS is trying to transfer data. I then get the error message:
“Need to run the object to perform this operation Code execution exception: EXCEPTION_ACCESS_VIOLATION” Please find table script below.
There have been some about a workaround if the script contains a WITHEVENT – but I have saved the package as VB Script and it does not contain any WITHEVENTS, so the workaround does not apply.
The user on Oracle is both role DBA and system SYSDBA.
Many Thanks, Nina
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Contract]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Contract]