I'm not having a syntax problem, I don't think, but the following is telling 0 rows copied, but I do know the file contains data...anyone have any ideas?
bcp "Privacy_OHM.[dbo].[Dat_up_log]" in D:\DATA\OHM\T0000001.log -T -S<servername> -fD:\DATA\OHM\Dat_log_In.fmtwhat does the fmt file look like?
and the first few rows of your .log file?|||Perhaps toss in an error file to catch the rows that bomb out?|||it was the format file
The redirected out put is essentially 1 column
The table has 3 columns and I forgot to "zero out" the column in the format file
Thanks guys...sql
没有评论:
发表评论