Any opinions on the best way to achieve two-way ftp transfers from within a Stored Proc?
DTS is of no use as it only goes one way
We have used the 'build a batch file to use the built-in ftp, then execute it with xp_cmdshell' but it's a bit messy
Has anyone used a CLI bcp tool? I've found one by CatFood Software that I'm considering using as it does it all in one go...
Any suggestions / comments / discussions appreciated.