I have always been using either SQL Server or text file logging with SSIS, since they are easy to review. Could you comment on potential usages (advantages/disadvantages) of some...

This is a great summary of the main things one would need to know about scripting as it relates to SSIS. Of course with .NET there are endless possibilities,...

Great package and article. Thank you! I am saving this one 😉

Thank you for sharing this obscure issue. I hope it saves me time someday.

Thank you for the article. Could you expalin how this line works:

set context_info @b-2

Why is there no equal sign?

I had no idea you could use PARTITION BY with things like MIN, MAX, COUNT, etc. :blush:

Thank you for the article!

All the critical comments aside (regarding proofreading), I liked the article. I haven't used filtered indexes previously and this gave me a good idea when I might want to...

Very sneaky! Thank you for sharing 🙂

Thank you for the article. It's building nicely on the methods of splitting strings by Jeff Moden and others. I am actually very curious about this sentence:

I've...

BobA 66314 (5/18/2011)

---

Thanks, Gary.

A) You ACTIVATE the CustomerRequestList queue (file: 080 EmployStaffManager.sql)

Why is there no need to activate the CustomersResponseToAskList queue? Is it because it is not carrying...

Since this was a pretty long article I had to put it aside and read it over the weekend. Just finished. I have to say this is probably...

Well done, thank you! I don't care how many times single user mode has been written about. We all can use another reminder, because this is not something...

Wow! Thank you for sharing this solution. Life would be way too easy without annoying problems like this.

Thank you both Craig and Wayne! This points me in the right direction.

Thank you for the article! I didn't even know this feature existed :blush: I suppose it wasn't publicized enough. It's incredibly useful, but, as Kendal pointed out,...