Hello, I have to import a flat file that has columns with text in multiple languages(EN,FR,IT,DE,NL). How can i import the text in SQL so that the text is written accordingly. I must mention that the collation I am using on the server is SQL_Latin1_General_CP1_CI_AS. Do you have any suggestions for this? Thank you!

Are you worried about the specific letters not to be lost? Since your file is set to a specific code page just use the same in your SSIS and all should be OK. The collation can be changed on per column basis, too. Not sure why it is needs to be limited to one choice.Arthur My Blog

I think you should be OK, as long as you have this column Nvarchar or Ntext or NCharGaurav Gupta http://sqlservermsbiblog.blogspot.com/

Thank you very much for the answers. It seems that the column data type I was using was Varchar and once I changed it into Nvarchar the problem was solved. No need to specify the collation for each column. Thanks a lot!