That works, thanks very much 😀

Sorry missed a bit, here is the query I am using.

UPDATE dbo.tblOpenDaily

SET Who = 'Result'

(SELECT TOP (100) PERCENT dbo.tblOpenDaily.[Entered Date]

FROM ...

Thanks, I wont tell you how long I have been looking for that but I was beginning to think I must have imagined it ever happened 😀

Welcome to my nighmare, as this is what I am doing to overcome this problem. 

Be careful if you have DTS packages that import/export data with a command to delete...

After much swearing and banging my head in frustration I finally sussed it.

When you import a previous version of DTS using the migration wizard you are able to run the...

Thanks, now I understand

Yes, I did try looking in BIDS but where are the  files stored?   I did a wildcard search on the server looking for my data files and came back blank.

Now do...

Now I did think that would be the obvious place but its empty. 

I also created an example where I imported a text file and saved it as a SSIS and that is...

Thanks Markus, now I can start to make my changes