I have a DTS package called "Package A". It contains an Execute Package Task which calls "Package B". Package A is scheduled via SQL Agent. When the job runs, it fails at the time Package B is called - the DTS log shows that Package A started "execute package task", but Package B has not started. SQL Agent log says

"Executed as user: HOSYD\admin_sql. ...Start: DTSStep_DTSActiveScriptTask_1 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 DTSRun OnStart: DTSStep_DTSActiveScriptTask_2 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_2 DTSRun OnStart: DTSStep_DTSDynamicPropertiesTask_1 DTSRun OnFinish: DTSStep_DTSDynamicPropertiesTask_1 DTSRun OnStart: DTSStep_DTSExecutePackageTask_1 DTSRun OnProgress: DTSStep_DTSExecutePackageTask_1; DTSStep_DTSExecutePackageTask_1: DTSStep_DTSDataPumpTask_1: 1000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 1000 DTSRun OnProgress: DTSStep_DTSExecutePackageTask_1; DTSStep_DTSExecutePackageTask_1: DTSStep_DTSDataPumpTask_1: 2000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 2000 DTSRun OnProgress: DTSStep_DTSExecutePackageTask_1; DTSStep_DTSExecutePackageTask_1: DTSStep_DTSDataPumpTask_1: 3000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCo... Process Exit Code 255. The step failed.

I am at a loss - how could a package be successfully called for execution but never started

To preclude some suggestions I must say that I've done my KB search and made sure all packages are called by name, not by GUID, and every task is executed on the main package thread (there are some OLAP processing and dynamic properties tasks withing both packages)

Thanks in advance
Soloist

This looks like the job step log.

Can you have both packages log to text file and we'll see if we can get a
better error from there.

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


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

job runs, it fails at the time Package B is called - the DTS log shows that
Package A started "execute package task", but Package B has not started. SQL
Agent log says:
DTSStep_DTSActiveScriptTask_1 DTSRun OnStart:
DTSStep_DTSActiveScriptTask_2 DTSRun OnFinish:
DTSStep_DTSActiveScriptTask_2 DTSRun OnStart:
DTSStep_DTSDynamicPropertiesTask_1 DTSRun OnFinish:
DTSStep_DTSDynamicPropertiesTask_1 DTSRun OnStart:
DTSStep_DTSExecutePackageTask_1 DTSRun OnProgress:
DTSStep_DTSExecutePackageTask_1; DTSStep_DTSExecutePackageTask_1:
DTSStep_DTSDataPumpTask_1: 1000 Rows have been transformed or copied.;
PercentComplete = 0; ProgressCount = 1000 DTSRun OnProgress:
DTSStep_DTSExecutePackageTask_1; DTSStep_DTSExecutePackageTask_1:
DTSStep_DTSDataPumpTask_1: 2000 Rows have been transformed or copied.;
PercentComplete = 0; ProgressCount = 2000 DTSRun OnProgress:
DTSStep_DTSExecutePackageTask_1; DTSStep_DTSExecutePackageTask_1:
DTSStep_DTSDataPumpTask_1: 3000 Rows have been transformed or copied.;
PercentComplete = 0; ProgressCo... Process Exit Code 255. The step
failed."
executed on the main package thread (there are some OLAP processing and
dynamic properties tasks withing both packages).

Allan

Thank you for the reply. It inspired me to look deeper into dts logs. I found that a particular step failed which caused the whole job to report a failure. However, the reason for the failure is still a mystery to me

The failed task is an Analysis Services Processing Task, which is set to LOCALHOS\MyOLAPDatabase\Dimensions - Rebuild Dimension Structure. After rebuilding dimensions for about 1 hour 30 minutes, it fails with the following message

Step Error Source: Analysis Services Processing Task
Step Error Description:Invalid processing option
Step Error code: 8004021D
Step Error Help File:
Step Error Help Context ID:1000440

Nevertheless, the dimensions seem to be rebuilt and the cubes are available after just data refreshing processing

Any help would be highly appreciated

Soloist

There used to be this problem

http://support.microsoft.com/default...b;EN-US;246015

Can you process the cube manually?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


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

failure. However, the reason for the failure is still a mystery to me.
rebuilding dimensions for about 1 hour 30 minutes, it fails with the
following message: