I have a package that loops thru files that may look like ths:
sometimes there may be more than one company survey:
Now, i need to process one file group at a time, t here will always be the four files together, the name of the company will be the company name to the underscore. but every group will have a q,r,s and c file. I want to proces them one company at a time, then move to the next set.
right now, i use a for each loop, to get every file, and process them by a variable to the _r.xlsx,_c.xlsx, etc....so, i want to take similar files, process them, then move to the next set. possible in ssis ?