Outstanding!! CoolWeb would you by any chance have a link to something so I can read up on this behavior. This issue has driven me bonkers for about 3 weeks...

Took a look at the link and although it is similar to my issue the posters did not explain the reasons for their recommendations. What I am looking for is...

Thanks CoolWebs for the reply but can you explain to me why the blocking is occuring. I have tried researching the cause but nothing in google or BOL has pointed...

Yes - the blocked spid runs just fine after the select * into completes

Thank you Pradeep. I will take a look at the article.

Not knowing everything is not scary. Boredom makes me look for new challenges. Being a DBA is awesome because there is always something new to learn or someone less experienced...

I played around with those roles last week while working on my SSIS issue and the user was able to schedule the job but I had to also create a...

Is there anyway you can post a copy of the error message?

This may help. I am just trying to undestand Integration Services and feel your pain.

http://msdn.microsoft.com/en-us/library/aa337083.aspx