SSIS on SQL Server 2008 R2
I have inherited an SSIS package that is failing when importing a spreadsheet. The part of the failure is in a data flow that consists of :- * an Excel Source Data Flow Component * a Derived Column Data Flow Component * an OLE DB Destination Data Flow Component
The table that I'm importing into is empty.
I'm not sure what else to look at. Any assistance is appreciated. Thank you.