Importing the Excel file into SQL Server via SSIS - Excel data is not in table format
Posted on 2010-01-06
I am new to the SSIS.
Could you please point me a right direction as I do not know what resources or ways are available to solve the issue.
I am trying to import the Excel data ( not table format) into the SQL Server via SSIS.
The error pop up message shows up as, "External table is not in the expected format".
Do I need to change the Excel data writing code in VB(A) before implementing the SSIS importing?