tsql - Bulk Insert Empty Columns UCS-2 Little Endian -

tsql - Bulk Insert Empty Columns UCS-2 Little Endian -

i have tab delimited file imported using mass insert command. have format file follows.

8.0 9 1 sqlchar 0 50 "\t" 1 field1 "sql_latin1_general_cp1_ci_as" 2 sqlchar 0 50 "\t" 2 field2 "sql_latin1_general_cp1_ci_as" 3 sqlchar 0 50 "\t" 3 field3 "sql_latin1_general_cp1_ci_as" 4 sqlchar 0 50 "\t" 4 field4 "sql_latin1_general_cp1_ci_as" 5 sqlchar 0 50 "\t" 5 field5 "sql_latin1_general_cp1_ci_as" 6 sqlchar 0 50 "\t" 6 field6 "sql_latin1_general_cp1_ci_as" 7 sqlchar 0 50 "\t" 7 field7 "sql_latin1_general_cp1_ci_as" 8 sqlchar 0 50 "\t" 8 field8 "sql_latin1_general_cp1_ci_as" 9 sqlchar 0 0 "\r\n" 9 field9 "sql_latin1_general_cp1_ci_as"

which works fine ansi files, receiving file ucs-2 little endian encoding.

my effort work utilize next amendments format file. stops errors, right number of rows empty columns. i'd avoid converting file if possible.

8.0 9 1 sqlchar 0 50 "\t\0" 1 field1 "sql_latin1_general_cp1_ci_as" 2 sqlchar 0 50 "\t\0" 2 field2 "sql_latin1_general_cp1_ci_as" 3 sqlchar 0 50 "\t\0" 3 field3 "sql_latin1_general_cp1_ci_as" 4 sqlchar 0 50 "\t\0" 4 field4 "sql_latin1_general_cp1_ci_as" 5 sqlchar 0 50 "\t\0" 5 field5 "sql_latin1_general_cp1_ci_as" 6 sqlchar 0 50 "\t\0" 6 field6 "sql_latin1_general_cp1_ci_as" 7 sqlchar 0 50 "\t\0" 7 field7 "sql_latin1_general_cp1_ci_as" 8 sqlchar 0 50 "\t\0" 8 field8 "sql_latin1_general_cp1_ci_as" 9 sqlchar 0 0 "\r\0\n\0" 9 field9 "sql_latin1_general_cp1_ci_as"

you're there, alter sqlchar sqlnchar

tsql sql-server-2008-r2 bulkinsert