Hi,

If memeory serves correctly, the answer is no with bcp.

I built a process for a customer that exported transactions every day and ftp'd the data up to an automated process.

I...

I can appreciate that this is a dead post but we have a client that experienced the exact opposite; while troubleshooting a server slow down issue, the IT manager found...

Hi,

I think you're asking how to pick a file from an ftp site, not from another SQL server.

I used dts to call a batch file that pulled a database dump...