Invalid collation name for source column 1 in format file

The good news is that it works for me. The bad news is that it doesn't solve your problem. I suspect there is a data issue going on, but I can't be sure. I will try copying the data to SQL and see if that makes a difference, although the error didnt' say anything about my file. I copied the files to the SQL server and ran the query, also changed the table name and no go.

Thank you for your help, I'm glad it works for you LOL I'll play with it tomorrow, maybe do some more searching. So much for getting it done today Try modifying the input file so that there is only a couple rows, then import it.

Does it work? Add more data, import it, etc If you have bad data, then you should be able to track it down using this technique. Hope it helps. I still get that collation invalid error. Red Flag This Post Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

The Tek-Tips staff will check this out and take appropriate action. Click Here to join Tek-Tips and talk with other members! Already a Member?

Join your peers on the Internet's largest technical computer professional community. It's easy to join and it's free. Register now while it's still free! Already a member? Close this window and log in. Join Us Close. Active Oldest Votes. There are a few other things you might consider changing: 1 - The sample wide table definition doesn't match your input file in a couple of ways: There is no source in your file for the NOT NULL column DateCreated - you might need a DEFAULT constraint to set the value - perhaps this is present but was omitted from the example table definition?

Improve this answer. Ed Harper Ed Harper Thanks Ed. I can see that this is going to be correct based upon my previous research. Yes - the missing columns in the larger table were due to the redact being a bit rushed. I had noticed the import was to a view, but there is nothing about it not working for a table - I thought. You are of course right that using a view is of course logical in the circumstances. Thanks also for the additional information regarding the identity insert.

My speciality is middleware. Actually, my ' Still no joy from the import. Giving up on this strategy. I think that these guys social. I tried a non xml format file, and tried renumbering. Login to reply. February 19, at pm February 21, at pm February 22, at am Thank you Mr. I'll give them a look! Our community of experts have been thoroughly vetted for their expertise and industry experience. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

All rights reserved. Covered by US Patent. Come for the solution, stay for everything else. Welcome to our community! I am trying to do the bulk insert with a format file and getting the following error: Cannot perform bulk insert.