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


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

And...

I have been running

sp_dropserver 'servername'
go
sp_addserver 'servername', local
go


and updating my MDAC

still no joy...
Nina

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!