Was dropping the table and using select into to create it again then selecting all from the table into an excel destination. Had to update the stored proc to truncate the table so that the datatypes would be the same on every run so meta-data in the package would match.