I am working on an SSIS package where I'm looping through 3 sheets in an Excel file to store all the data in a CSV file.
The first sheet and the third sheet have similar column structure but the 2nd one doesn't.
I want to skip the processing of the 2nd sheet so inside the Foreach Loop Container I have a disabled Expression Task with an expression precedence constraint @[User::SheetName] == "Sheet1$" || @[User::SheetName] == "Sheet3$"
that connects to the Data Flow Task that does the processing of the Excel file.
My issue is when I execute the package only the first sheet is processed and then execution is completed.
CodePudding user response:
I needed to remove single quotes that were placed around my sheet name variable whenever the sheet name had a space in it.