bcpy
bcpy copied to clipboard
Python Wrapper for Microsoft SQL Server bcp Utility
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...
In my dataframe, I have a line ```df['Time'] = pandas.to_datetime(df['Time'])``` but when i run ``` bdf = bcpy.DataFrame(df) bdf.to_sql(sql_table, use_existing_sql_table=True) ``` and I get ``` SQLState = 22008, NativeError =...
When `bcp` command failed for any reason, `bcpy` throws an error like Exception: Bcp command failed. Details: CompletedProcess(args=['bcp', '.dbo._csv_upload_oplf79ekgyuwgfkubyhi', 'IN', '/tmp/3RIe1BaQV7aSt80nVThsz', '-f', '/tmp/xytYaR1whpyB3SWXsfyTE', '-S', ',1433', '-b', '50000', '-U', '@', '-P',...