SQLTeam.com | Weblogs | Forums

Why we do the change over to projet association in msbi?



I needed to know the utility of doing a transformation in venture association in the association supervisors in ssis

Thanks and Regards,


Hmmm, I think you mean, "I need to know the value of converting a connection to a project-level connection". Is that right? (I think English is not your first language. The phrase, " transformation in venture association in the association supervisors" does not really mean anything.)

The value is that, if a connection is used by more than one package in a project, you only have one object to create and maintain per project, instead of one per package. This is important if your project has more than one package using the same connection. In OOP terms, it's like using class inheritance. It also avoids repetitive code, which eases maintenance. This is also a good example of the Don't Repeat Yourself (DRY) principle.