Home Forums SQL Server 2005 SQL Server 2005 Integration Services General Question - How best to validate an excel spreadsheet prior to running ssis pkg RE: General Question - How best to validate an excel spreadsheet prior to running ssis pkg
Phil Parkin
SSC Guru
Points: 247210
More actions
March 5, 2010 at 1:31 am
#1129025
I would do it the way you suggest - but as part of the package. Step 1 - Script Task to validate spreadsheet format.