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 expected, taking an expected amount of time and reporting the correct number of records imported. However, the count on the table is still 0. Same result with a second file I attempted to import into a another table
The database was in
BULK_LOGGED mode. The target table was newly created without any indexes.
Any help would be appreciated.