One option: use a Script Task to write each resultset to the same file one after the other.

Another option: use a Transformation Script Component to change the rows of each resultset to a single wide string, then use the Union All Transformation to bring them into one resultset before writing that to a Flat File Destination.