I am trying to export data into Excel file and it is working fine, but appending data for each run.
So, added two execute SQL task in SSIS package to DROP and create table as suggested. But it is giving below error for DROP table task, not sure what is my mistake
[Execute SQL Task] Error: Executing the query "DROP Table
" failed with the following error: "Table 'Excel Destination' does not exist.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Any help will be of great help