Querying EXCEL using Excel Source Data Flow Task in SSIS 2008
I am using an excel source data flow task in SSIS to load specific tabs from spreadsheets into a database.
This works fine as long as the tab exists, as shown using the Preview option below.
However there are situations where the tab may not exist and then I want to perform another action.
I am trying to incorporate an IF EXISTS statement into my query but am having issues with this, see below
any guidance appreciated, thanks