Thanks for the reply RBarryYoung. I will take a look at SSIS.

Seth,

The derived table version worked a treat. Thanks again for the help 🙂

John

Seth,

Really appreciate the comments. Just to respond:

1. You're right, I should have taken out the order by.

2. This was me experimenting, something I had read that I wanted to try....

That's much tidier, thanks.

I...

I think I've answered my own question here. Writing out the question here actually helped me to find a way of doing it.

This is what I've got now:

DECLARE @start_date varchar(21),

@temp_date...

You're right, this will not work, the date fields are different. I've changed my approach and found a solution using table variables. I don't think it's the most efficient but...

Hi Darren,

I didn't have any luck with the SessTimeout fix. As you said, its not exactly the same problem so thats probably the reason it didn't work.

At this stage I'm...

Rajan John/John Marsh,

I've logged to Windows with SQL Server Service Account and created test files on the target server without any problem so I'm 100% sure that the account has...

Hi Darren,

Thanks for the suggestion, I'm going to try it now. I'll report back shortly...

Hi,

I typed the share name in plain text but it didn't make any difference.

I made a temporary directory without spaces, same result.

The target partition is NTFS on a Windows Server...

Hi,

Yes I restarted the server service. However, one thing I was slightly unsure about was how to change the NullSessionShares value. It is a REG_MULTI_SZ type so I firstly typed...

I just tried the registry update and it still doesn't work.

So I guess that implies that the problem is not permissions related right?

Hi,

I've verified that the account SQL Server is running under has write access at the share level and the file system level so there's no problem there.

The KB article does...