Hi,

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 9.2.0.1

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.

The Scenario:
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.

Any Suggestions???

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]
GO

CREATE TABLE [dbo].[Contract] (
[ContractID] [int] IDENTITY (1, 1) NOT NULL ,
[ContractName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ContractDescription] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ContractAdminOffice] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ContractAdminOfficeAddress] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ContractAdminOfficeCity] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ContractAdminOfficeState] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ContractAdminOfficeZip] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ContractAuditOffice] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ContractAuditOfficeAddress] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ContractAuditOfficeCity] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ContractAuditOfficeState] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ContractAuditOfficeZip] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ContractSolicitationNumber] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ContractNumber] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ContractTypeTerms] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ContractContractorType] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ContractStart] [datetime] NULL ,
[ContractFinish] [datetime] NULL ,
[ContractComplete] [datetime] NULL ,
[ContractAwardDate] [datetime] NULL ,
[ContractDefinitizationDate] [datetime] NULL ,
[ContractLastItemDelivery] [datetime] NULL ,
[ContractRFPNumber] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ContractType] [float] NULL ,
[ContractPriceCeiling] [float] NULL ,
[ContractPriceEstimated] [float] NULL ,
[ContractSharedOverrunRatio] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ContractCostOriginal] [float] NULL ,
[ContractNegotiatedChanges] [float] NULL ,
[ContractTargetPriceCurrent] [float] NULL ,
[ContractTargetPriceEst] [float] NULL ,
[ContractCostEstAuthUnprc] [float] NULL ,
[ContractBudgetBase] [float] NULL ,
[ContractUser1] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ContractUser2] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ContractUser3] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ContractUser4] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ContractUser5] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ContractUser6] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ContractUser7] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ContractUser8] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ContractUser9] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ContractUser10] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[upsize_ts] [timestamp] NULL
) ON [PRIMARY]
GO

setuser
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Contract].[ContractBudgetBase]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Contract].[ContractCostEstAuthUnprc]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Contract].[ContractCostOriginal]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Contract].[ContractNegotiatedChanges]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Contract].[ContractPriceCeiling]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Contract].[ContractPriceEstimated]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Contract].[ContractTargetPriceCurrent]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Contract].[ContractTargetPriceEst]'
GO

EXEC sp_bindefault N'[dbo].[UW_ZeroDefault]', N'[Contract].[ContractType]'
GO

setuser
GO