I would highly recommend using the command line version of WinSCP, called WinSCP.com. It works great, can handle "passive mode", and SFTP and is also freely available.

Ok, thank you.

Wow, there's no way to do this in SQL server 2012?

I use Action Outline. It is wonderful and is very much like windows explorer with the tree / branch structure. I couldn't live without it. I keep all my code...

Our data comes from many sources, the best answer I can give is "God knows where". I've got to find the time to build something which will help me to...

Well lets just say that we have sort of inherited some very interesting processes. Quite often we receive flat files of data, possibly exported from Excel or god knows where....

Apparently this was a bug in the Oracle driver. The solution is to install an updated driver. Here are the details in case anyone else has same issue:

http://forums.oracle.com/forums/thread.jspa?threadID=337842&start=15&tstart=-2

Thanks,

Paul

Your solution works perfectly. Thank you so much !!!:-)