Phil

Currently only one, but we have proven that we can run multiple SSIS servers, with centralised logging / monitoring / reporting.

As for the number of packages, I have a model to get this down to a total of 3.

The problem I'm facing is that others (calling themselves architects) are complaining that we are not using the full capability / power of SSIS, such as Dataflows, new logging / recording aspects of 2012.

If I go with Project deployment do I lose the scale out capability?

I believe that I can pass parameters, but need to check that out.

From a logging perspective I need to check if 'volume' is being logged, just having start and end time to totally useless unless you have some concept of volume processed. If I have to log my own volume then I may as well log the duration!

pcd