Tuesday, November 11, 2008

SSIS loading Excel validation error

I ran into a situation today where I needed to have an Excel Source for an Excel file that would not always exist at the path specified in the ExcelFilePath property. This would cause the SSIS package to fail when the Excel file did not exist since the Data Flow Task could not validate the Excel file.
The simple fix was to right click the Data Flow Task and go to Properties and set the DelayValidation property to True.