Three thoughts:

1. Is the destination table empty at the beginning of the load? I seem to remeber being told that this can prevent the fast load option from being...

I believe you can install a second instance in the same "group" as the existing instance, but it will be failed over too if the default instance gets failed over....

Jim,

I too like linked servers, in moderation.. I think that the right tool for the right job is the important thought.

I do agree that providing sprocs and such to...

Ed:

If you have more than one instance configured to point at 1433 then I agree the first one to start would get it, however, any such setup would be sheer...

How does it assembly the XML how does it write it? We need a lot more detail..

CEWII

My first thought was CAS, Code Access Security, has access to that been restricted..

CEWII

I don't believe there is such an option.. It would be great but I've never seen any such thing..

CEWII

The issue in that link is Oracle. Are you using Oracle? Are pushing data to it or from it, to it then that article probably applies, from it...

The single most important sentence in that response was "The instances do not need to operate as separate clusters". Run them together..

CEWII

I came from an environment that used the phrase "Excel Databases". You know the conversation is going to be ugly anytime that come up..

CEWII

I believe this is a known issue, unless the Oracle drivers are 64-bit then you are forced to run the package with the 32-bit DTEXEC..

CEWII

What is the error?

Also it is probably a permissions issue, does the account that SQL Agent runs under have permissions on the objects being manipulated?

CEWII

I have had this happen as well..

Do a drop, call an exec of the proc, then recreate it.

The call forces the engine to forget about anything it has cached for...

That was a good explanation. Good work..

CEWII

I wish I could go, I enjoyed SQL Connections immensely in Nov 2007..

CEWII