I have a package that has the following steps:

Transform data task : EXEC_usp_CreateDPDistancesHTM (stored proc)
Connection properties : Create htm data file ( file created from stored
proc output)

on success

Execute SQL Task : Rename Data file to territory name (renames file
created above)

This was working for some time but recently, with some tweaking of
processes, the final task does not run, regardless of the success of
the Transform data task. The file is created correctly via the
Connection properties.

I cannot work out why this success is being ignored. I went into
disconnected edit to see the precedences for the rename task and this
is shown below:

Precedence Constraint 1:
PrecedenceBasis 1
StepName DTSStep_DTSDataPumpTask_1
Value 0

Precedence Constraint 1:
PrecedenceBasis 1
StepName EXEC_usp_CreateDPDistancesHTM
Value 4

On checking the details for the Transform data and Connection
properties, these appear to be as follows:

Task EXEC_usp_CreateDPDistancesHTM:
Description: EXEC_usp_CreateDPDistancesHTM
Name: EXEC_usp_CreateDPDistancesHTM
SourceSQLStatement: EXEC usp_CreateDPDistancesHTM
Transformations: DTSTask_DataPumpTask_1

Connection Create HTM data file:
LastOwnerTaskName: EXEC_usp_CreateDPDistancesHTM
Name: Create HTM data file

Any ideas why the "Rename Data file to territory name" step does not
run, given the previous steps success?

Cheers

Mark

stainless wrote:

No need for any help now thanks.

Worked out that one of the precedence entries was a "phantom" entry
from an earlier incarnation of my package. deleted one, correcetd the
other and all works ok

Cheers