Cannot Perform Bulk Insert. Invalid Collation Name
Can anyone advise me on what's going wrong? Jennifer Format File Contents: 8.0 16 1 SQLCHAR 0 2 "" 0 Space "" 2 SQLCHAR 0 4 "" 1 YearID "" 3 SQLCHAR 0 2 "" 0 Space "" 4 Lester VincentSydney Post #273875 David BurrowsDavid Burrows Posted Wednesday, April 19, 2006 6:28 AM SSCertifiable Group: General Forum Members Last Login: Today @ 9:03 AM Points: 7,838, Visits: 9,305 To bulk But since this is a log file, maybe it doesn't. weblink
You cannot post EmotIcons. This entry was posted in SQL / Stored Procedures, SQL Server 2000 on 25/Apr/2009 by Steve Ngai. I guess this is a text file with one line per record? The time now is 23:01. http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=35526
Monday, June 18, 2012 10:30 PM Reply | Quote 0 Sign in to vote I've tried pressing the carriage return and saved it. 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 The format file should describe the file you are importing, not the table.
Can that happen? I was confused. However, you say this is a Unix file. MS SQL Server Advertise Here 778 members asked questions and received personalized solutions in the past 7 days.
Now, I've tried something you have mentioned. 8.0 15 1 SQLCHAR 0 23 "|" 1 DateAndTime "" 2 SQLCHAR 0 50 "|" 2 Session SQL_1xCompat_CP850_CI_AS 3 SQLCHAR 0 0 "|" 0 If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.Would you like to participate? Join the community of 500,000 technology professionals and ask your questions. It seems to be looking for a collation name ...In BOL, their example shows "SQL_Latin_General" for the "pub_name" field in their example.I will try replacing the quotes with that and see
But that's a hypothetical discussion. https://spiinl.wordpress.com/2010/05/03/cannot-perform-bulk-insert-invalid-collation-name-for-source-column-1-in-format-file/ You cannot delete other topics. Can that happen? Powered by vBulletinCopyright ©2000 - 2016, Jelsoft Enterprises Ltd.Forum Answers by - Gio~Logist - Vbulletin Solutions & Services Home Register New Posts Advertising Archive Privacy Statement Sitemap Top Hosting and Cloud
Well, I was talking about the format file, and I was careful to say "format file" twice in my post, so when so you started to talk about the file looking have a peek at these guys You may want to go back read them again, more carefullly. bcp databasename.owner.tablename out temp.txt -S servername -TPress enter for each prompt and Y to save file Enter for filename to accept default (bcp.fmt) or type in your own nameThis will give When maximum precision is used, valid values are from - 10^38 +1 through 10^38 - 1.
You cannot edit HTML code. This column is a datatype of real and is it what bothering the load?Known is a DROP, Unknown is an OCEAN. Post #274086 Lester VincentLester Vincent Posted Thursday, April 20, 2006 6:34 AM Valued Member Group: General Forum Members Last Login: Tuesday, April 27, 2010 1:33 AM Points: 67, Visits: 134 Thanks http://scriptkeeper.net/cannot-perform/identity-insert-is-already-on-for-table-cannot-perform-set-operation-for-table.html Invalid collation name for source column 1 in format file ‘C:bcp.fmt'. 3 Replies It took me a while to finally figured what what went wrong to fix the above error.
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. I tried the format file without a newline and indeed I got exactly that error message. You cannot delete your own posts.
Forgot your password?
Which, if this is a Unix file, is unlikely to be a collation based on CP850 (unless it's an AIX machine). I was confused. Then you should have good CR-LF at the end of each line." ? Reply With Quote 12-17-03,16:15 #4 Brett Kaiser View Profile View Forum Posts Visit Homepage Window Washer Join Date Nov 2002 Location Jersey Posts 10,322 OH MY GOD All I had to