Monday, March 19, 2012

BIDS:Precedance Constraints not visible

In the SSIS Package we have, the precedance constraints between the executables become invisible. It is difficult to find out if there are already constraints between the executables in the designer window.

Is this a bug? What is the easiest way to get them back?

- Gaurav

Hm, so the precedence constaint exists and appears in the package explorer tree, but not in the diagram?

Could you open a bug on betaplace and attach the package with this problem? How did the package get into this state?

You may try resetting the diagram layout: Format \ Autolayout to rebuild the diagram layout, hope this helps.

|||

Yes. The precedance constraints are very much there. They are just not visible.

When we try to re-add constraints an error is raised: Only 1 constraint can exists between 2 executables.
Hence, seems like some kind of issue during re-draw.

We have to wrestle around for sometime with the tasks and (by luck!) sometimes the constraints appear back.

We cannot afford auto-layout since, we have organized the package as per our specific layout needs.

|||Important thing is that it does not cause any functionality issues!

But, definately causes difficulty in understand.|||

Gaurav Singh wrote:

Important thing is that it does not cause any functionality issues!

But, definately causes difficulty in understand.

I've definately seen this happen before but its impossibe to repro on demand.

-Jamie

No comments:

Post a Comment