Alvin

that works perfectly!

many thanks for your help

Hi Alvin

I know how to get a filedate by activex...

Dim oFSO

Dim oFile

Dim sSourceFile

Set oFSO = CreateObject("Scripting.FileSystemObject")

sSourceFile = DTSGlobalVariables("SourceFileName").Value

Set oFile = oFSO.GetFile(sSourceFile)

msgbox oFile.DateCreated

' Clean Up

Set oFile = Nothing

Set oFSO =...

Mark Thank you -I hadn't realised I could us SELECT CASE like that. However on using, the line gets replaced as...

'SELECT CASE WHEN [SKU] LIKE %EC% THEN EC WHEN [SKU]...

Mike

that seems a good idea - I'm very much a newbie at the structural element of SQL Server

I'll give it a go

Thanks

Paul

many thanks, the hard way is often the best way!