June 24, 2002 at 6:06 am
I am trying to bulk insert a file that is only 1 line (big file).
I have tried \r and \n for field terminators.
Here is the last line of my format file:
22SQLCHAR 020""22GROUP_NUMBERSQL_Latin1_General_CP1_CI_AS
Here is my error:
Cannot perform bulk insert. Invalid collation name for source column 22 in format file 'Z:\AL_BCBS\eligibility_1.fmt'.
-Kevin
June 25, 2002 at 4:54 am
First what version of SQL are you using? What is the collation of the destination table column or database? If different then consider changing the format file to say the same as the destination and see if it will work.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
June 25, 2002 at 8:57 am
I am using sql 2000. There is no problem witht he colation. I am going from text file to db table.
The format file must not match the data being sent. My work around was to create a table with 1 column which is the length of the full row. I have imported the data to the table as large blocks and I am substring'n the columns out of my fat column table (if that makes sense)
-K
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply