I've been trying to import data from an Excel file to SQL Server DB. Strangely, I have been successful 2 times since yesterday and unsuccessful hundreds of other times. I thought playing with the connection string in SQL Server Import and Export Wizard can solve my problem but it doesn't work now.
It seems like this error can be related to the language and I changed the language of Microsoft SQL Server Management Studio to match my windows language in this path: Tools--> options --> Environment --> International Setting --> "Same as Microsoft Windows" and then restart the MSS Management Studio and didn't work. Also connecting to MSS Management Studio with windows authentication and SQL Server Authentication are all tried.
When I connect with windows authentication, the result of select @@language is Deutsch and when I connect with SQL Server authentication the result is us-english. I tried are different combinations and it doesn't work after all. The language settings of my system is super complicated. It seems like they have changed it to English for me but in its core you can still see German as the language in some situations.
Also I have tried set language English; in a SQL Server query and it didn't help because it is not directly related to import/export wizard. There's a field for language in the wizard itself (when making connection) and I played with that, too; didn't help either.
Any idea how I can pass this error? Also I don't have a clue how it worked 2 times.
The connection string that I use in the wizard and I think worked once is like this:
Data Source=MyServerName;Initial Catalog=MyDestinationDB;Integrated Security=True;
User ID=MySQLUser;Password=*********;MultipleActiveResultSets=True;ApplicationIntent=ReadWrite
And the error that I get is as follows (I have get many other errors but this one is the most serious one)
Had the same issue with SQL Server Import/Export wizard.
In my case, the solution was to set English (United States) in Time & Language -> Region Settings -> Regional format.