The first screen capture is the one before I added the empty line and the second screen capture is the one after I added the empty line. Welcome to the quirkiness of format files. Nor have I talked about the data file in my previous posts. Lester VincentSydney Post #273875 David BurrowsDavid Burrows Posted Wednesday, April 19, 2006 6:28 AM SSCertifiable Group: General Forum Members Last Login: Yesterday @ 9:03 AM Points: 7,838, Visits: 9,305 To bulk have a peek here
Is that your table collation? What do you mean by " But why not simply edit the format file in Notepad, so that it looks good in Notepad. Thanks! Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Reply With Quote 12-17-03,16:17 #5 rdjabarov View Profile View Forum Posts Registered User Join Date Jul 2003 Location San Antonio, TX Posts 3,662 That'll do it Reply With Quote 12-17-03,16:35 #6 Then you should have good CR-LF at the end of each line." ? I will file your great tips in a safe place. I have never seen a collation with that name before.
When I try a BULK INSERT Code: BULK INSERT Year_End..XLAT_Company FROM 'd:\data\tax\XLAT\XLAT_Company.csv' WITH (FORMATFILE = 'd:\data\tax\XLAT\XLAT_Company.fmt') I get the message Server: Msg 4839, Level 16, State 1, Line 1 Cannot perform How did you compose the format file originally? Thanks Bangaaram Known is a DROP, Unknown is an OCEAN. https://social.msdn.microsoft.com/Forums/sqlserver/en-US/f8e5098b-b304-45f5-86a7-fb1c86590419/bulk-insert-not-working-with-interchanged-columns-in-sql-server-2000?forum=transactsql Then you should have good CR-LF at the end of each line." ?
If there are only ASCII characters in the range 32 to 127 (plus those newlines), you can't go wrong. Home | Weblogs | Forums | SQL Server Links Search: Active Forum Topics | Popular Articles | All Articles by Tag | SQL Server Books | About Please start any new Invalid collation name for source column 16 in format file '\\wbhq.com\dfsdv\iDataInt\GOPFiles\GOPFormatFile. The SQL-92 synonyms for decimal are dec and dec(p, s).p (precision)Specifies the maximum total number of decimal digits that can be stored, both to the left and to the right of
Invalid collation name for source column 15 in format file But, there doesn't exist any collation on this column in the destination table. https://www.experts-exchange.com/questions/22617510/Cannot-perform-bulk-insert-Invalid-collation-name.html I copied your format file, set up a test table and a test file, and all went well. All rights reserved. I am able to load the files with the format file now. :)Known is a DROP, Unknown is an OCEAN.
Which, if this is a Unix file, is unlikely to be a collation based on CP850 (unless it's an AIX machine). http://sauvblog.com/cannot-perform/cannot-perform-a-dos-based-backup.html Should I edit the Format File only in Notepad? Many thanks for your help, David. But if there are not equally many fields in the same row you will not be able to load the file with BCP/BULK INSERT.
But here are some ideas. So simple whe you know how.I hope this 'trial-and-error dialogue is going to help at least onw other needy person!CHeers,Lester VincentSydney Post #274066 David BurrowsDavid Burrows Posted Thursday, April 20, 2006 Invalid collation name for source column 3 in format file 'c:\essai.fmt'. Check This Out In such case, the last field should not have "|" as the delimiter, but "\r\n" (if it is a Windows file).
If there are characters > 127, you will need to pick the correct collation. You cannot post IFCode. Post #273883 Lester VincentLester Vincent Posted Wednesday, April 19, 2006 6:55 AM Valued Member Group: General Forum Members Last Login: Tuesday, April 27, 2010 1:33 AM Points: 67, Visits: 134 Thanks
txt'. If this is your first visit, be sure to check out the FAQ by clicking the link above. Didn't work.(b)tried (again), by inserting "" (double quotes), as per your original example, and this time IT WORKED!!! Post #273894 Lester VincentLester Vincent Posted Wednesday, April 19, 2006 7:18 AM Valued Member Group: General Forum Members Last Login: Tuesday, April 27, 2010 1:33 AM Points: 67, Visits: 134 Thanks
Known is a DROP, Unknown is an OCEAN. Furthermore, looking at your file, there are 15 fields on each row. Invalid collation name for source column 1 in formatfile Cannot perform bulk insert. this contact form I use version 8.0 only.
SQL Server Developer Center Sign in United States (English) Brasil (Português)Česká republika (Čeština)Deutschland (Deutsch)España (Español)France (Français)Indonesia (Bahasa)Italia (Italiano)România (Română)Türkiye (Türkçe)Россия (Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) That would indicate that the format file has only line-feed at the end of the line, not CR+LF. This means that there should be 15 fields in the format file.