bcpy
bcpy copied to clipboard
BCPY with varbinary column
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'')