That's an excellent point William, and I did not address permissions in this article. Good catch.

You can probably already guess that I'd script the permissions in re-executable T-Sql.

Thanks for pointing...

Hi Scott,

Great article and excellent use of SSIS Package Configurations. I really like centralizing the application tier (Dev, Test, Prod) selection at the configuration server. Elegant solution.

...

When I interviewed with Brian Knight, he handed me his laptop and said "Write me a query to do such-and-such." The SQL Server instance had been corrupted. There was no...

Hi Max,

Thanks for sharing your experiences and insight. We disagree, but I respect where you're coming from.

:{> Andy

Hi Max,

There are different mindsets for DBAs and database developers. There's stuff they share, and stuff that one can learn from the other. It's folly to assume...

Test-Driven Development doesn't work in every situation. In my experience, nothing works in every situation. That's one of the reasons I titled the article "An Example..." in the first place.

My...

Here here!

Great idea - nice to see it implemented and making a difference.

:{> ANdy

Great editorial Tony!

A lot of people managing large corporations (and some managing small ones) do not understand the value database professionals bring. Finding meaningful ways to bridge...

Excellent article Mike!

I really like your writing style, and you have some cool things to say. Troubleshooting is about as scientific as our jobs get and I...

I do what Jeff does. I know of no better way to proactively monitor the actual performance of my code without some form of instrumentation.

:{> Andy

Hi Steve,

Great editorial and valid points. BI could help here, imo. But you're right: it's expensive and time-consuming (which is saying the same thing twice) - at...

Thanks for all the comments!

Matthew - Like Jack, I usually use the Konesans Trash Destination for an endpoint as well. I didn't mention it here. I also use the Script...

Hi RBarry,

I didn't take it as a criticism - I appreciate the comment.

In my experience, scripts don't convert well from SSIS 2005 to SSIS...

Thanks for all the encouragement!

RBarry, I mostly write about SSIS 2005 because I sense most of the SSIS market is using SSIS 2005. I could be...

Hi Rana,

I'm not sure this article will help you. It was about SSIS and didn't really touch on C#.

Andy