xc

Indeed it was, ended up withe the following

Public Sub Main()

Dim SourceDirectory As String = "E:\Data"

...

Made a couple of changes to the directory locations, added a source & target directory and converted to VB code as I'm using 2005 and it doesn't like c#

...

Cheers Lowell,

With a bit of tweaking that gave me what I needed, and saved me hours of frustration

The files will only be extracted once, I'm putting them in subdirectories as I don't know the process that the 3rd party software will use to reload them

Do I just create a variable to hold the record count, in the same way as you created the directory variable, if so how do I reset to 0 once...

The documents are being migrated to a new application, so at the moment the date of the order is unimportant as all documents will eventually be moved

With a bit of tweaking I got it to work

Many Thanks

I've sorted it. I originally tried to use 'REPLACE' but couldn't get the syntax right, so I used SUBSTRING instead,

SUBSTRING( @Yesterday, 1, 4 ) + SUBSTRING( @Yesterday, 6, 2 )...

That's the one!

One other thing, how can I get rid of the hyphens so it just shows 20150713

Sorry for the delay in responding, been off ill.

this one just errors telling me it's incorrectly formed.

I suppose what I really need is something that checks the year, month and...

That's fine for sql, but it won't work in expression builder, will it ?

I'll give it a go. Many thanks for the quick response

Well spotted, didn't think of that

A few attempts to get the right syntax, but got there eventually, many thanks

@Dest1 + (DT_STR, 4 , 1252)DATEPART( "year" , GETDATE() ) + "" + RIGHT( "00" + (DT_STR,...