Which, if this is a Unix file, is unlikely to be a collation based on CP850 (unless it's an AIX machine). This entry was posted in SQL / Stored Procedures, SQL Server 2000 on 25/Apr/2009 by Steve Ngai. Code: 8.0 13 1 SQLCHAR 0 0 "," 1 ETRSCompanyCode SQL_Latin1_General_CP1_CI_AS 2 SQLCHAR 0 0 "," 2 TaxDBPSId SQL_Latin1_General_CP1_CI_AS 3 SQLCHAR 0 0 "," 3 CleanUpPSId SQL_Latin1_General_CP1_CI_AS 4 SQLCHAR 0 0 I was confused. weblink
Then you should have good CR-LF at the end of each line." ? Nor have I talked about the data file in my previous posts. After you have added the empty line, it should works. I tried your solution and it worked for me.
You cannot post replies to polls. I does not talk about the data file. I tried the format file without a newline and indeed I got exactly that error message. Not 100% sure here, but worth a try. 4 SQLCHAR 0 255 "\r\n"
Furthermore i read somewhere that if you use version 7.0 instead of 8.0, you could simply ommit the collation. Leave a Reply Cancel reply Enter your comment here... Known is a DROP, Unknown is an OCEAN. Wierd.I don't understand what you'r doing whith this line feed ...
Erland Sommarskog, SQL Server MVP, [email protected] I've tried pressing the carriage return and saved it. I am able to load the files with the format file now. :) I'm glad to hear that it sorted out eventually! The time now is 07:01 PM. Microsoft Access Help General Tables Queries Forms Reports Macros Modules & VBA Theory & Practice Access FAQs Code Repository Sample Databases Video Tutorials Sponsored http://dbaspot.com/sqlserver-programming/188030-bulk-insert-error-cannot-perform-bulk-insert-invalid-collation-name.html I don't have Column 3 in the database table. 0 Featured Post Highfive + Dolby Voice = No More Audio Complaints!
If you see the content of format file I've posted, the last column of the file is somewher in between pointing to the table's column. Copyright © 2002-2016 Simple Talk Publishing. I always love the content and the way you write . You cannot post HTML code.
Bulk Insert - Fixed Length File P: n/a Jennifer I'm trying to do an insert using Bulk Insert with a fixed length file. my review here Erland Sommarskog, SQL Server MVP, [email protected] Thursday, June 14, 2012 4:00 PM Reply | Quote 0 Sign in to vote Check that there are no unexpected characters in the file, such Erland Sommarskog, SQL Server MVP, [email protected] Tuesday, June 19, 2012 10:15 PM Reply | Quote 0 Sign in to vote I have thousands of rows in my file and how can I guess this is a text file with one line per record?
Erland Sommarskog, SQL Server MVP, [email protected] Ok. http://ecoflashapps.com/cannot-perform/cannot-perform.html Should I edit the Format File only in Notepad? Our new SQL Server Forums are live! No trackbacks yet.
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 Again, while the error message from BULK INSERT is not the best in town, it talks about your format file. That would indicate that the format file has only line-feed at the end of the line, not CR+LF. check over here Also, should I use a 7.0 format file or 8.0 format file?
Didn't work.(b)tried (again), by inserting "" (double quotes), as per your original example, and this time IT WORKED!!! What do you mean by " But why not simply edit the format file in Notepad, so that it looks good in Notepad. dbforums Yak CorralRadio 'Rita dbForums Member List I'm Good Once as I ever was The physical order of data in a database has no meaning.
I will file your great tips in a safe place. So, I was wondering if I should mention the delimiter for that column and not the last column? Can anyone advise me on what's going wrong? Now running this same thing on my production files that I received from the client I still get the zeroes in my numeric columns.
But that's a hypothetical discussion. I was not able to repeat this. 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. http://ecoflashapps.com/cannot-perform/identity-insert-is-already-on-for-table-sql-server.html dpursell Starting Member 3 Posts Posted-01/14/2005: 17:21:05 SQLCHAR makes sense, except I was getting errors bulk inserting into a numeric column in my table so I "assumed" that it
However, I checked the file again using notepad and it shows up no space between the last column of the first row and first column of the second row. 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 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. You cannot post EmotIcons.