BCP SQL Server import failure cause? [Unable to open BCP host data-file] -
i have inherited process bunch of tables being prepared locally python , pushed database. fails , don't know why, though first thought access rights. have admin access database (and server?) using sql server authorisation. here example bcp command being churned out python script:
bcp "[test].[dbo].[isp_2014_flat]" in "flat_files/isp_2014_201504011504.csv" -u admin -p xxx! -c -t ^ -s "xxx20039999\dzuhe00999,2311"
sqlstate = s1000, nativeerror = 0 error = [microsoft][sql server native client 10.0]unable open bcp host data-file
what can check might responsible problem?
thanks,
andrew
Comments
Post a Comment