Thanks for that Brian, yes unfortunately that's the way the 3rd party has their application set up. Will experiment as you say setting up another role with the necessary...

No luck I'm afraid Peter, I am able to add the access database as a linked server using 'Microsoft.Jet.OLEDB.4.0' as the driver, but using a dynamic OPENROWSET with same it's not...

Thanks for the replies, - that's a good point Mike, I had forgotten about that consideration

Thanks Vinny and CTracey, This was the route we have been considering but it's re-assuring to know of others using said route

Hi Yelena and Shawn,

Much appreciated, you've both been a great help

Sorry

just noticed that I was referring to Per "Server Licensing" when it was killed off after SQL 7

Thanks for that Yelena and Shawn,

Yelena, we are using the server in for a Web application, so that obviously explains the per processor licensing agreement that was purchased.  

One of...

Thanks for that Yelena and Eddie. I'd known about the hyperthreading scenario with twice the numver of processors being shown, but that's giving me some useful background as to...

Hi Tony,

Thanks for that.  Yes I was aware of the Robocopy Return Code Nasty (the first time I set up a robocopy job and spent many minutes scratching head)

This appears to have been resolved under the following post

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=227036

Dan,

Have you also got the master database too ?  If so all you need to do is ensure that your SQL Server installation and directory structure is the same as...

Thanks for that Mike,

Essentially you could also programmatically ignore the flow stored in the DTS job with this and decide your own flow at run-time I guess.

Mike,

Is there any way that you can trap the success of failure of the objPackage.execute.  It doesn't appear to return anything

Thanks

Simon

Hi Greg

Great, Almost there, but I would also like package B to run through and finish its own conditional branching when any of the tasks internal to it fail.  I have a...

Hi Helen,

I assume that you are using a VBScript and Excel Automation, rather than using a linked server or using OLEDB and openrowset.  Have you got an example of your...