'BCP No Rows Copied Runs Locally but Not Remotely

I built this BCP Call that works perfectly on my DEV host, but not on my PROD host. It is executed by a .bat file on the host that contains this call to BCP. When I run it from an elevated command prompt on the host, it runs fine, but when the same .bat file is executed remotely, it executes, but copies no rows. The input file, data.psv, is the same on both DEV and PROD hosts.

The command is:

bcp DATABASE.dbo.TABLE in data.psv -S HOSTNAME -f Snowflake_Imp_File_Format6.Fmt -T -b 20000 -e errors.txt -h"TABLOCK"

Any help is greatly appreciated. I have replaced the HOSTNAME with it's IP and SQL Port, but that didn't work either.

copy bcp

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'BCP No Rows Copied Runs Locally but Not Remotely

Sources

Related Questions