DTSRUN.EXE APPLICATION ERROR

Question

Post reply

DTSRUN.EXE APPLICATION ERROR

Aswani kumar

Mr or Mrs. 500

Points: 556
More actions
September 14, 2005 at 6:48 am

#67480

WE have lots of jobs to execute ,each job will call more DTS.some times we are getting this error:"DTSRUN.EXE APPLICATION ERROR"-MEMORY CANNOT BE READ.
can any one help on this.

Thanks,
J.Aswani kumar

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Jonathan Stokes SSCrazy Eights Points: 9861 More actions · Answer 1

How are you kicking off the application?

Is it by typing this on the command line?

dtsrunui.exe

------------------------------
The Users are always right - when I'm not wrong!

Richard Kemp SSC Journeyman Points: 76 More actions · Answer 2

Sounds lilke you're running out of swap space! This is what we call a Bad Thing in the world of ETL. You can verify this is the condition you're experiencing by checking the Event Viewer and seeing if you're getting out-of-memory-type events.

To rectify, you can configure your DTS packages to run fewer concurrent threads/processes. You can go into your package design, file->package properites, and in there set the maximum number of concurrent steps. By default this value is 4, which is often more than many systems can handle. Set it to 1 or 2.

Another thing you should look at is transactions and batch size. By default each transformation step runs the entire table-to-table transform as a single transaction. If you're transforming a million records, that's a lot of rollback! So you can set a batch size of say 1000 to minimize system resources during transformations. In designer, right-click on the transform line/task and look for batch size.

Let us know how it goes!

- Rick

Aswani kumar Mr or Mrs. 500 Points: 556 More actions · Answer 3

Thanks Richard Kemp..

This is the error which is popuped ,memory is not a problem.we have enough space in server.

We will run this multipel DTS by using jobs.

dtsrun.exe - Application Error

The instruction at "0x02ef931c" referenced memory at "0x00b16ee0". The memory could not be "read"

chris.tidwell Newbie Points: 5 More actions · Answer 4

I am getting the same error. When I run the DTS package from Enterprise manager, I get no errors. When I run it from DTSrun.exe I get

"0x7c8327f9 regerenced memory at 0xffffffff. The memory could not be 'read'. "

I am tranferring 450,000 records from an Oracle database. The transaction runs just fine, I get all the data in the destination table and the log file does not note any errors.

I have my batch insert size set to 10,000.

Even when I change my query such that I transfer 0 tags, I get the error message at the end of the execution.

Batch file command: dtsrun /s (local) /u sa /p "" /N dtsGetRecords /l C:\DTSLog.txt