DTSRun causes The Memory could not be "read" application error



Hi,

I've got this dts package in sql server 2000 sp4 that has several
transformation tasks with an oracle database (10g) as the destination.
The package executes successfully when run through the dts designer but
when run using dtsrun, I get the following error at the completion of
all tasks in the dts package. The data inserts into the oracle database
but i always get this Application error

The Instruction at "0x7c8327f9" referenced memory at "Oxffffffff". The
memory could not be "read"

Does anyone know how I can fix this?

Thanks
Lyn

.



Relevant Pages

  • Re: DTSRun causes The Memory could not be "read" application error
    ... > I've got this dts package in sql server 2000 sp4 that has several ... > transformation tasks with an oracle database as the destination. ...
    (comp.databases.ms-sqlserver)
  • Re: Timeout on a task?
    ... loss. ... > We're using VB6 to use Automation to write a DTS package in memory, ... with SQL Server 2000 as the destination. ... > For smaller feeds that process faster, ...
    (microsoft.public.sqlserver.dts)
  • RE: Resultat in eine Textdatei speichern
    ... Destination wählen ... Nun hast du ein DTS Package, ... hier hinein das gleiche SQL von der Prozedur genommen. ...
    (microsoft.public.de.sqlserver)
  • Re: How do I dynamically change output text file properties?
    ... The procedures extract the data and I can individually create a DTS package ... of a destination source when that source is a SQL Server table, ... You can use a dynamic properties task to browse a text file ...
    (microsoft.public.sqlserver.dts)
  • Leading Zero Is Dropped
    ... I have a DTS package that has an Excel spreadsheet as the source and SQL ... Server database table as the destination. ... Some zip codes have leading zeros but when using a simple Copy Column ...
    (microsoft.public.sqlserver.dts)