Hello Experts Exchange
I have a Excel spreadsheet (Please see attached) that I'm trying to import into SQL Server but I'm having a nightmare trying to do it, everything I have tried has failed.
I have followed the instructions on this web page but it did not work.
Several of the columns come back with the error of;
Column "Tool Code" cannot convert between Unicode and non-Unicode string data types.
Can anyone help me to create a SSIS package that will import the data into SQL Please?