i'm trying to use bcp to input some data into a table which has columns accepting null values. i have tried using /c and i've also tried using /f with a format file modified to look like this:
1 SQLCHAR 0 0 "" 0 column1
2 SQLCHAR 0 10 "," 2 column2
3 SQLCHAR 0 0 "" 0 column3
4 SQLCHAR 0 10 "\n" 4 column4
etc. . . and i always get "attempt to bulk copy an oversized row. . ."
i have tried to made my data look like this:
i've tried (with different fmt file)
and nothing seems to work. i have counted and recounted - i have the same number of data columns in my text file as are on the server, and the NULL values are allowed. . .
what's going on?