Thanks for the reply

Yes, it can be done. I have a feeling that the (more) locked down W10 work environment os the problem. I'm now fighting the security team.

The process...

Hi Martin
That's not left field at all.
I use SQL server to modify and consolidate data from around 100 organisations.

With the help of the wonderful guys...

Thanks guys. So many responses and all pointing me the same way!

My decision that I didn't need a loop was based on the single file process, but I...

Hi guys
Thanks for the help.
I had a rethink about the process. I've had no problem with using 7zip in an SSIS Process task on a 'static' file.

Thanks Erikur
Where the hell did the emoticons come from? I typed a P!  It should read [User:PathCurrentFile]

I've tried various versions of escaped quotes but they seem to...

Thanks to everyone who helped me.

brad.mason 's answer works great. I don't know why I ddn't think of it earlier. SQL is happy to ignore the SUBSTRING selects...

Hi Guys thanks for the support and suggestions.
The file spec is:

Thanks for the quick responseZZartin
It's already set as raged right. I've tried most variations of format and encoding! It doesn't seem to make a difference.
Steve

That's true. IF it was a 1972 model. And I generally agree about the 6 digit alphanumeric sequence. But as I now live in Australia where AZZ000 is a valid...

I've used passwordsafe previously and I'm currently using the portable version of KeePass Password Safe.

However for my work network login I have my password list printed out in 18...

Thanks for the reply Koen.

While...

I don't have a facebook account (Does it make me unemployable if I refuse to share my thoughts and movements with everyone?)

However if I did have one I'd be happy...