I'd like to use the Bulk Insert Task using a format file to a target Server/Database/Table. The table may or may not already exist. Is there anyway to have the Bulk Insert Task in SSIS 2008 drop and re-create the table from my SSIS Format File as part of the process?
+3
A:
Why not put a task (SQL Task) in front of the Bulk Insert task that checks for the existence of the table, and if it doesn't exist, create it?
Randy Minder
2010-01-22 18:25:26
Beat me to it!-that is exactly what you would have to do.
rfonn
2010-01-22 18:26:27
The problem is I'm generating the SSIS Format File dynamically based on input from an Excel Spreadsheet. That means the target table structure can vary.
Nissan Fan
2010-01-22 19:56:15
Since I failed to mention the need for a dynamic table structure I will accept this answer to the benefit of future people who may ask the question.
Nissan Fan
2010-01-25 20:49:35