Import of flat file into SQL Server Management Studio fails
With this error: Error inserting data into table. (Microsoft.SqlServer.Import.Wizard)Error inserting data into table. (Microsoft.SqlServer.Prose.Import)Object reference not set to an instance of an object. (Microsoft.SqlServer.Prose.Import) In my case this was due to extra carriage returns at the end of the CSV file – SSMS doesn’t like them! Remove them in a text editor and try again.... » read more