Great points and that is coming from read world experience not from some NoSQL marketing hype engine.

Thank you for your insight!

Good article David

I like your use of some snippets of real world examples and how you used what you wrote about to help solve them.

Now I agree with Jeff as...

Excellent, well written, and very informative article. Keep up the great work.

Nice article! Good level of detail and a nice level of complexity. Thank you

I am the same way Stan and from what I can tell there is an audience for the environment discussion.

Who knows I might dust off my writing skills and see...

Kenneth,

It really depends on what you want to do. If you know that you have lets say 2 environments DEV and PROD then you can configure all of...

The need access to the SSIS database and ssis_admin to be able to execute a package.

Well not exactly the windows user must have proper permissions defined on that server, it simply means that SQL Server users cannot execute packages (simply).

Thanks Peter - handy little script.

Remember in-order to execute the script that executes the SSIS package you need to be logged into that SQL Server as a Window's Account - SQL Server accounts do no...

Josh, I want to reiterate that I really enjoy and appreciate your article and hope that you will write more in the future. I was just stating that all...

Nice article - well done. I thought I would add an additional option to the mix. I am feeling extra cynical this am

Option 5. Explain to...

David I want to thank you for posting this comment. What you said about these kind of scrutiny exercises was right on the money. First time and long...

Jeff,

Outstanding article, nicely done with great examples.

I am certain this misuse is rampant in the real world and your examples help clarify where to look for these pitfalls.

A very nice and complete article - thank you for your efforts in creating this.

I like the Excel idea to manage some test cases and data, interesting approach.

Scott