Success, got this working.

Installed named instances on both nodes and it's fine. I suppose its quite logical that you can't install a named instance on both sides, as when one...

It's because we calculate date parameters to be passed to the command, these are worked out in a stored proc, then we call isql...

I think I've answered the problem though,...

Don't know about a resultset but you can certainly copy a SQL table to Excel using DTS - add two connections then use a transform data task. If you can...

restore database dbname from disk='drive:\path\filename.ext'

Can't use sp_attach_db unless the files we removed first with sp_detach_db.

How did u run your DTS job ? If u ran it from SQL EM on your client then DTS looks for the Oracle client components on your PC, however...