I have several DTS packages and I have scheduled them.
The Agent starts them up but never gets a complete
status. I stop them manually and look at the log and the
DTS package itself completes successfully.

Can anyone help with this please.

Thanks
Alan

Here is the error I get:

Executed as user: HUSSMANN\BRIBESA. DTSRun: Loading...
DTSRun: Executing... DTSRun OnStart:
DTSStep_DTSExecutePackageTask_1 DTSRun OnFinish:
DTSStep_DTSExecutePackageTask_1 DTSRun OnStart:
DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish:
DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart:
DTSStep_DTSDynamicPropertiesTask_1 DTSRun OnFinish:
DTSStep_DTSDynamicPropertiesTask_1 DTSRun OnStart:
DTSStep_DTSActiveScriptTask_2 DTSRun OnFinish:
DTSStep_DTSActiveScriptTask_2 DTSRun OnStart:
DTSStep_DTSDynamicPropertiesTask_2 DTSRun OnFinish:
DTSStep_DTSDynamicPropertiesTask_2 DTSRun OnStart:
DTSStep_DTSDataPumpTask_1 DTSRun OnProgress:
DTSStep_DTSDataPumpTask_1; 999 Rows have been transformed
or copied.; PercentComplete = 0; ProgressCount = 999
DTSRun OnFinish: DTSStep_DTSDataPumpTask_1 DTSRun
OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun
OnFinish: DTSStep_DTSActiveScriptTask_1 DTSRun:
Package execution complete. Process Exit Code -
1073741819. The step failed.

Hi Alan,
Check this link... maybe you will find the problem.
http://support.microsoft.com/default...;EN-US;Q269074
Also make sure you close connection after finish you pkg.
JFB

"Alan Ayers" <alan_ayers (AT) irco (DOT) com> wrote

OK I looked over all this information and here is what I
found. The job is running on the server using the agent
signon, the agent signon has full access to the database
and has network access for any com components within the
package. The package actually runs and completes all steps
(after job fails I look at the log and all steps complete
successfully) but an error message does appear on the
server.

DTSRun.exe - Application error
The Instruction at "0xbb82089" Referenced memory
at "0x02903ac8". The memory could not be read.

Click ok to terminate the program.

I found the problem.

I execute another dts package which is the first step. In
that step I must execute on the main package thread and
make sure the connection is closed. Then in the main
process I do the same thing and they now work.

Thanks for your help. Alan

Good.. and that option also helps the pkg speed.
JFB

"Alan Ayers" <alan_ayers (AT) irco (DOT) com> wrote