Two things to address 1st.

1) You would have to make an assumption about the column you are sorting on. In this case c3, correct? That would be sorted...

Check out Microsoft's Project REAL solution. This gives you a step by step description of how they think a SSIS implementation should be setup.

The most common configuration setup is:

-Environmental...

While shrinking each database in a production environment wouldn't be recommended, this does come in handy if you need to rein in your DBs on local or dev. Who...