Trouble with executing package 1

[Jozopiso]

Hello all,

my troble is probably very simple.
My package contains 100 of 'Execute SQL Tasks', which are ordered in hierarchy, so between them are all kind of flows .

If i try to execute whole package it can't make any update on server. But when i trying to execute task by task it works perfectly.
Connection between tasks and server is ok.

Any idea?

Very appreciate

jozef

 

[dbomrrsm]

Probably due to a conflict of one SQL task locking due to another running - when you kick them off one by one do you allow the task to finish before doing the next? If the answer is yes then I would say this is the problem.

If it is what you need to do is create the flow using on completion or on success workflows (found under workflow in the DTS designer window. this will then make the execution of possible conflicting tasks flow much better.

[blue]DBomrrsm[/blue]