ok, just figured it out for what i needed, in my previous testing it kept appending - pain in my butt.
initially, all i had on my control flow was an export task, the data flow of that was just two datasources, sql exporting to excel (after testing i found it was appending).
i had to:
1. create a file system task in control flow, deleting the file.
2. create a sql task, excel connection type, i used my previous excel connection for this, then used a create table script as my sql statement
3. left my previous export object the same, then linked the flow of these in this order described.
hope this helps anyone else out there.
i've read of other examples out there that would delete rows, and leave white space in the excel files. not what i would have wanted for a solution either.
and to me, a simple task such as this should not have been so hard to find information on, or that hard to figure out - but it was for me. what gives msft?