DTS PACKAGE STEP PRECEDENCE?

[beechill4]

Hi,

i have a dts package as follows:

1 micosoft for oracle odbc connection
15 steps which pull data from this oracle database into different sql server tables
1 step which deletes the data in the sql tables.

when i execute this package, the 15 steps execute first, and then the delete runs. what i want to do is run the delete first and then the import (15 steps)

i have tried to change the order but keep getting messages such as:
'defining precedence betweeen the selected items is not valid'

is there anything i can do to change this?

 

[MDXer]

Select You delete task then ctrl click one of the source object for you transform task. Right click go to workflow and select either on sucsess or on completion.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[beechill4]

Hi,

i'm afraid that gives the same outcome as before.

the steps i followed were:
1. right clicked on delete
2. ctrl-clicked on the oracle source.

then went workflow - on success

any other ideas?

 

[JohnDTampaBay]

Do you already have a precedence defined from SQL Server to Delete? If so, you will need to delete that constraint before creating the new precedence. Otherwise its just a circle, no beginning or end. Check Disconnected Edit for the Delete task and see if there are ghost constraints from the Oracle task. Good luck!

--John
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)

 

[beechill4]

hi,

i have it working now.

i used ctrl-alt click and it worked for me.

Thanks for your help, it set me on the correct path