If the OP would ever come back and explian what he was really looking for it might help..

CEWII

It is entirely possible the VPN is only making the problem worse..

That is a lot of transforms.. It might make sense to see if breaking the package down to...

3m huh.. Still, I bet the sproc version runs in under 20 seconds.

CEWII

Agreed.. WHAT?

You need to give us a LOT more information. I would equate this to "its broke, how do I fix it?"

CEWII

I'm actually a little surprised they are making you change them on a production machine.. It is usually viewed as too risky and that new standards are not retroactively...

Ahh, yes, BIDS Helper.. That is a truly wonderful tool..

CEWII

I didn't quite plan to do the whole thing or spend so much time on it myself but I kind of treated it as a challenge to see whether I...

Ok, here is my rough solution..

I think it covers all the sections. But there are a couple spots you need to look at, particularly around line 68 related to...

Not easily.. The package is stored...

I have a handle on what is going on in TAG1, I'm trying to wrap my brain around how to do it as a set based operation.

CEWII

While I understand full logs you are asking for 2 lines.. It helps to know the exact error number, severity, and state. The state can tell us a...

Ok, so it looks like the work table is built essentially from:

SELECT csh.*

FROM ClkCaseHdr AS cch INNER JOIN CaseStatusHist AS csh

...

It depends IS a valid answer.. However, I then ask, "tell me about WHAT it depends on and how that might affect the solution". I'm not asking for...

So depending on your query mix it is fully possible to have an entire database cached in RAM..

CEWII

Goto the errorlog on SQL and capture the two lines that show the login failure and post them here. It will help.

CEWII