So I installed sql server locally and deployed a dtsx package to the integration services catalog from VS. SSISDB database is already there, so thought I'd create the SP there.

The...

Think I found the issue, administrator visual studio had deployment target of 2016, which I assume defaulted the language to 2015.

The answer is to update the format to

Format=EXCELOPENXML

and then works

the file already exists, which only has headers

Sorry, probably not explained very well...

So it gets one id and writes the data to file, then loops to get next id and writes that data into same file and...

Thanks Phil, I'm not sure if a rename task is what I need.

Currently all data is produced into one file.

I want to have a separate excel file which has data...

Thanks Sue,

Works perfectly!