Groups | Blog | Home
all groups > sql server (alternate) > october 2005 >

sql server (alternate) : DTSRun causes The Memory could not be "read" application error



lyn.duong NO[at]SPAM gmail.com
10/25/2005 5:35:36 PM
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
John Bell
10/29/2005 12:00:00 AM
Hi

I am not sure why this should happen but you may want to check that your
arguements are correct http://support.microsoft.com/?kbid=308801 and that
you can the same versions of MDAC on the machine it is running on and that
it is consistent (see MDAC component checker http://tinyurl.com/6gsv )
http://support.microsoft.com/?kbid=255900

John
[quoted text, click to view]

lyn.duong NO[at]SPAM gmail.com
10/30/2005 9:21:51 PM
Hi John,

The mdac problem is relevant to sql server 7.0 and I've checked the
other kb. I don't pass any arguments. I have already got the latest
service pack installed for sql server 2000.

Lyn

[quoted text, click to view]
AddThis Social Bookmark Button