question

NAGI avatar image
NAGI asked

Why presedence constraints not working

Hi, i have ssis package contains parallel tasks which contains presedence constraints,based on presedence constraints the one flow will execute ,but here executing both flows ,it is in schedule,but if we execute manually it will work properlly can you give assest me ASAP THANKS NAGI
ssisconstraints
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Fatherjack avatar image
Fatherjack answered
It is confusing when you say this works in debug mode but not when started via SQL Agent but in my experience the thing to watch with constraints is that their logic is right - when you have more than one constraint (true and false) and they have different conditions with AND and OR logic. This could only be different in your two scenarios when you consider the different accounts that are running the package and the security permissions that they might have. Without knowing the steps that are involved it is difficult to know exactly but are there file locations or data access steps in the package where the error occurs? What does the package log have in it, any error details?
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.