Microsoft SQL Server's bulk copy utility
1
vote
0answers
469 views
Unable to open BCP host data-file error
Having problem using BCP via xp_cmdshell.
I exported the table data to a file as .dat but when I try to import the file to a new table, I am getting the below error. The SQL Server service and the ...
1
vote
0answers
105 views
SQL Server BCP imports, but table still has 0 records
I ran the following command from the command line on SQLServer 2008 R2
BCP C4L.dbo.districts in C:\TEMP\districts.sdf -f C:\TEMP\districts_import.fmt -T'
No errors were reported and it ran as ...