Programmabilities Blog

2008-03-28

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).

Labels: sql