sql server - WildCards in SSIS Collection {not include} name xlsx

Question

I have a process built in SSIS that loops through Excel files and Import data only from those that include name Report.

My UserVariable used as Expression is: *Report*.xlsx and it works perfectly fine. Now I am trying to build similar loop but only for files that DOES NOT include Report in file name.

Something like *<>Report*.xlsx

Is it possible?

Thanks for help!

Matt

Answer 1

In your loop, put a Script task before your first task. Connect those two with a line. Right click that line and set Constraint Options to expression. Your expression would look like this...

FINDSTRING(@var, "Report", 1) == 0

Where @var is the loop iterable.

Only files without "Report" inside will proceed to the next step.

Referencing this exact answer. SSIS Exclude certain files in Foreach Loop Container