I was perturbed to learn, only after reading over half of this article, that the security-by-proxy functionality is not a feature of SQL Server, but rather a third party application.

I am a developer at heart, but have grown into more of a manager and DBA role over the last few years. Back in the classic ASP days, I wrote...

I realize you've already accepted an answer, but I'd like to offer an alternative solution that doesn't have anything to do with XML.

/*the table where your data...

• This reply was modified 4 years, 8 months ago by  jbowers. Reason: removed an apostrophe from the first comment, which was throwing off the formatting
• This reply was modified 4 years, 8 months ago by  jbowers.

Brilliant - thanks for sharing! That's a great example of creatively using an existing index rather than adding another index to the table. I'll definitely add the binary search technique...

It's interesting that you can do this, but can you give a practical reason why you would want to do this over more traditional collections? Are there performance benefits? Storage...

• This reply was modified 4 years, 8 months ago by  jbowers.

I like articles like this one from which I can learn new, niche tips and tricks... especially where regular expressions are involved, because I'm not that good at them!

I question...

I, too, chose the last answer, not because I thought it would actually fail, but because none of the other three answers contained the correct date.

This is brilliant in its simplicity. No matter how much I learn about SSIS, it's always a pleasure to run across a gem like this. Thanks for sharing!

Darko, nice article with lots of great detail. I thought this might give me a 4th option for my query results; Results to Text, Results to Grid, Results to File,...

Good article, and I agree with the earlier replies that the code to conditionally set the background color of a row can be easily achieved with one expression on the...

You state that the wizard method of project deployment "is of course not suited to deploy projects to the production server". As someone who is just upgrading from SSIS 2005...

Another option would be to simply provide a default value for the user variable that holds your file name. This could be beneficial if you have "downstream" tasks in your...

Rudy, I think several of the previous posters have never found themselves truly "locked out" of a SQL Server instance and thus, do not grasp the relevance of your article....

We use XML package configuration files in our development and production environments, primarily to store connection info and relative path info. We store our packages in the file system, rather...