Thanks SR that approach will def work.

Darren

Hi Paul,

I do run it with the SET NOCOUNT ON statement, which as you said should suppress the message, however in this case it does not.

I figured it has something...

Ron, your assitance put me on the right track. 

After putting in the switches I was able to confirm that by all accounts the files were been downloaded.

I did a...

Again Lowell, many thanks for taking time to reply.

I checked the properties on folder and all Server Administators have access to it, and obviously at some other point I made sure...

Lowell, thanks for taking time to reply.  I appreciate it.

The User who runs both SQL Server and SQL Agent is a dedicated SQL Account with Admin privileges on the Server.

The...

Thanks Tom,

Had the same problem, did exactly what you suggested and everything is back in working order.

Many thanks for saving me a weekend of grief, now I have one...

Hi All,

First off I would like to start by saying this SP looks brillant.  It does exactly what it says on the tin.

I know this topic was talked about a...

Hi

I do something similar, and I use the file system object to achieve it.  Code outline below.  May be of some use.

Darren

--FILE SYSTEM OBJECT VARIABLES

DECLARE @FSO int

DECLARE @OLEResult int   -- If...

Many thanks for your replies.  Samba sounds very interesting, and may well work.  I am trying to have the Network lads review samba with a possibility of having it installed...