SSIS > VS Export wizard: table to Excel

After using the SSIS > VS Export wizard for table to Excel, you must add DROP TABLE Query to the Event Handlers tab or else it will error the second time it is reRun.

SSIS > VS Import wizard for Excel to table:

• Be sure to only checkmark Results$.
• Be sure to Select Delete table option.
• Be sure to Change Results$ name to Destination table name.
• If there is an error, it is often because a row in Excel has a NULL but the table column is NOT NULL (so add a blank to the Excel field).