In my problem I had a Queue of work to be performed by an SSIS package, we wanted an efficient way to group these request to lessen the burden on...

awesome solution!

Hi,

Try checking out this article:

http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/64014/

its a little cryptic but you have actually use the ADO Enumerator to do what you are trying to accomplish.

Hi Guys,

Thanks for the great feedback, this post is ment follow up to how I resolved this issue as to maybe help others in the future

This query is a very...

So one question concerning READ_COMMITTED_SNAPSHOT, have you ever implemented something like this? It sounds really great only issue is with a growing tempdb and a slight performance hit to inserts,...

Thanks a ton Micheal!

Hi,

thanks for responding,

so the answer to your first question: In a seperate Audit table

and the answer to your second question, 'What' would be easy as the SQL that gets...