Home > Cannot Perform > Cannot Perform Bulk Insert. Invalid Collation Name

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

It's getting late here, (Sydney time), so I will try your suggestion in the morning.I have never created a format file, and am not sure how to use the following information You can't say that BCP and BULK INSERT excels in clear error messages. Wednesday, June 20, 2012 2:16 PM Reply | Quote 0 Sign in to vote Thankyou very much for taking such pain. Join and Comment By clicking you are agreeing to Experts Exchange's Terms of Use.

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

See below: If you can see in the image, its before the year 2006. txt' ) Table Definition: CREATE TABLE [dbo].[FlatFile_GOP] ( [YearID] [smallint] NOT NULL , [PeriodID] [smallint] NOT NULL , [CompanyID] [smallint] NOT NULL , [UnitID] [smallint] NOT NULL , [AccountCode] [int] NOT Privacy Policy Site Map Support Terms of Use Register Help Remember Me? this content cause I never succeeded in starting a bulk insert ... Grandpretre Starting Member 5 Posts Posted-04/28/2005: 04:59:32 quote:I had the same problem on any format file ending in a