You use Package Proxy when you want to run it under a different account to the agent. Its useful if you have loads of different boxes and you...

It sounds like security. But Bids is an odd beast. Try running it on the server itself

The reason why you would want to do this, is that basically every business using...

Ive just started writing an article exactly on this very same subject! You seem to have beat me to it. Good work.

Paul

Have you tried creating a table using the excel sheet as a template? Often if you do this the data type will be varchar rather than nvarchar. ...

I havnt actually tried this but I wouldnt think so. But I can tell you that running two instances of SQL R2 Standard on the same box as Server...

In addition to trying everything else posted you could try this.

Having been through a similar problem years ago using a poorly specified machine I had to resort to using...

You need to have a look at Aggregated Fact tables.

Its a massive subject, places to look are the estimated and the actual query plans, use profiler to see actually whats running on SQL, use perfmon to...

Have you made sure that identity impersonate is set to true?

I have just done my 70-450 today (841/1000). My advice it to buy the pocket admin guide and buy the 70-432 MS study book. It gets...