OK! got it to work. I have a File Task to copy a template over to my destination in a package. Then another package that has an Execute SQL Task to create the sheet and the data flow. I run the first package to copy the template and then the data flow package. Works wonderfully well.