SSIS package that will create automatic a excel file for every city?

See more:

SQL

MS-Excel

SSIS

I am doing a SSIS package, that will read the Data from the SQL table and will create a Excel file for every city of a country, in that file will keep all the information of that city. My Question is how you create about 175 Excel file, I know how to create 2 or 3 with the Conditional Split ? but 175


For Example : I have the following fields in my SQL table

Name-->John, Last name ->Smith, Address->M street, city->Miami

so I will have to create a Excel file with the data of the people for each city