OK. That answers what happens when the nested proc exists but is missing permissions, sort of... The nested / inner procedure is not returning any data. If we assign execute...

Has anyone found a resolution for this issue?

Great little article. Several years ago while I still was a junior DBA, I ran into this very issue. It was quite perplexing at the time (and unfortunately involved people's...

Right. I expect that it would. But that process runs every night and the index rebuild process only runs twice per week. Only at the times when the index rebuild...

No. We are using Standard Edition which does not support online rebuilds of indexes.

OK. I got mine to perform more like expected.

On the DTSX step (Data Flow Task), I changed the DefaultBufferSize from 10485760 to 40485760.

Total execution time went from 20 minutes+...

There are no wait states indicated. Also, what is strange is that the 2208 rows are present in the target table as soon as the "stall" period begins.

After many hours of google and msdn searches, I am still frustrated with this option. It works fine at the development machine in BIDS but at the server it never...

Hopefully someone can help out here. I've created, compiled, and distributed the .dll to the server and my local machine.

When I create the report, it runs and looks great on...

I really like the ideas here. I've worked through the article and am having an issue I believe reported in the previous post... I build the project, copy the .dll...