SSIS Excel Import conversion error
Posted on 2014-10-08
Hello Experts Exchange
I have a Excel spreadsheet I'm trying to import in to SQL Server using SSIS wizard.
I have several columns all are fine apart from one, where SSIS see the field as a Double field, its not its a text field.
I opened the Excel file selected the column and used Text to columns to set the field to text, this normally works for me but at the moment it does not solve the problem.
If I was to save the package and open it up in Microsoft Visual Studio, is there a way I can get this column in, in its text format?