I think we have a bit of a language barrier here, but we don't understand what you mean. "Running packages across a server" doesn't mean anything to us. You need...

If you have a question about something not in the article, please start your own thread in the SSIS forum.

SAN. He tells this as an anecdote that a well tuned SAN can really fly.

You really need to learn some terminology as you'll get confused, confuse us, and possibly make a big mistake.

A cluster is 2 or more servers combined with shared storage that...

My advice is to set the space you need for the next 3 months. You don't want to manage space too frequently, and you don't want too much OS level...

It is, that's my neighbor's house.

Can you check what commands it was last running? DBCC INPUTBUFFER? It's possible that it's stuck and needs to be killed.

As John mentioned, more information and preferably code, would help.

I would learn towards a CTE if you have temp tables you are trying to use.

Craig is correct in that this is a network connection/visibility error.

However I'm not clear. You say two servers, and also mention a cluster. Are these both in a cluster? Are...

I saw a script from Kim Tripp recently that would restore to a point in time, and then check for changes, restore to a newer point, repeat.

The script is in...

Are the files in the main folder or sub folders? Make sure the Agent does not have a proxy as well.

I tend not to run this from a remote server,...

Bob Lee (11/11/2010)

---

I'm impressed. You should tell the folks at RedGate actually seeing this is what has me interested too. I sent in the information to have someone...

GilaMonster (11/11/2010)

---

Plus it should be 'the valley of the shadow of joins'

Yea though I walk through the valley of the shadow of joins, I shall fear no scans, for thou...

OCTom (11/11/2010)

---

What's the horse's name? I see you're riding bareback. A saddle would allow you to mount a bracket to it and have the iPad in front of you the...

I haven't. Just pinged him to see if he's OK.