DTSRun.exe Application error

#1

Hi All,

I have a DTS package that transfers data from a table into excel or
text files based on the option specified. But every now and then, it
hangs when called from an ASP page via a job.
I get a DTSRun.exe error specifiying that "The instruction at 0xxxx
referenced memory at 0xxxx. The could not be "read"."
It only happens for this package and usually when creating a new file
(One file is created per day and repeatedly overwritten.)
The following info is available in the event log.
"Faulting application dtsrun.exe, version 2000.80.534.0, faulting
module dtspkg.dll, version 2000.80.760.0, fault address 0xxxxxx."

Any help is appreciated...
Thanx

P.S. Could it be that the job is executed before the prior execution
completed?

#2

SQL 2000, but what service pack level?

Select @@version

--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm

Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com

"Bonnie" <Bonnie (AT) discussions (DOT) microsoft.com> wrote

Quote:

Windows 2003 Server Standard Edition SP1
Microsoft SQL Enterprise Manager Version: 8.0

I have a DTS Package that runs fine except when scheduled:

Server reports error:
DTSRun.exe - Application Error

The instruction at "0x7c8327f9" referenced memory at "0xffffffff". The
memory could not be read.

Click OK to terminate the program

The job shows as executing until the OK is clicked on the server error
message.

The scheduled job will then report the following error details:
Executed as user: PDPLACE\jobagent. ...tart: Drop table
LK_IPPS_EMPLOYEE Step DTSRun OnFinish: Drop table LK_IPPS_EMPLOYEE
Step DTSRun OnStart: Copy Data from Results to LK_IPPS_EMPLOYEE Step
DTSRun OnProgress: Copy Data from Results to LK_IPPS_EMPLOYEE Step;
1000 Rows have been transformed or copied.; PercentComplete = 0;
ProgressCount = 1000 DTSRun OnProgress: Copy Data from Results to
LK_IPPS_EMPLOYEE Step; 2000 Rows have been transformed or copied.;
PercentComplete = 0; ProgressCount = 2000 DTSRun OnProgress: Copy
Data from Results to LK_IPPS_EMPLOYEE Step; 3000 Rows have been
transformed or copied.; PercentComplete = 0; ProgressCount = 3000
DTSRun OnProgress: Copy Data from Results to LK_IPPS_EMPLOYEE Step;
4000 Rows have been transformed or copied.; PercentComplete = 0;
ProgressCount = 4000 DTSRun OnProgress: Copy Data from Results to
LK_IPPS_EMPLOYEE Step; 4671 Rows have been transformed or copied.;
PercentComplete = 0; Progre... Process Exit Code -1073741819. The
step failed.

The jobagent account has sysadmin privlege and dbo for the database
rights.
The SQLSERVERAGENT service is setup to run using this account.

Any ideas?

Thanks,
Bonnie

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

DTSRun.exe Application error

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

DTSRun.exe Application error - 05-15-2005 , 06:55 PM

Re: DTSRun.exe Application Error - 12-01-2006 , 02:52 PM