Navigation

RSS: Matt Pavey RSS Feed

Tuesday, November 11, 2008 @ 8:24 pm,SSIS,Matt Pavey

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.

The opinions expressed on this website are my personal opinions
and do not represent my employer's or my clients' views in any way.