Can you please list all variables you used?
I was able as well to make the package work by using "CREATE TABLE `" + @[User::region] + "` (
`my_field` VARCHAR(50)
)" before adding the Dataflow task. When I added the dataflow task and assigned the variable to the Excel Destination it didn't alow me. what did you use for the variable ‘Subgroups’ ?
Thanks in advance