bcpy icon indicating copy to clipboard operation
bcpy copied to clipboard

BCPY with varbinary column

Open code02el478 opened this issue 4 years ago • 0 comments

while running bcpy which pulls the data from sql server database table, one of the column in table is varbinary, and bcpy was throwing error to load the data. Need to improve code if the column is varbinary. error listed below.

Exception: Bcp command failed. Details: CompletedProcess(args=['bcp', 'db.dbo.Test_load', 'IN', 'C:\Users\AppData\Local\Temp\1\ZFfVlRanQcdud693OIJqN', '-f', 'C:\Users\AppData\Local\Temp\1\XR3YAxE7OhPFOPabU7CUb', '-S', 'testhost', '-b', '10000', '-U', 'user', '-P', '@password', '-F', '2'], returncode=1, stderr=b'')

code02el478 avatar Oct 26 '20 13:10 code02el478