CODEWITHSUNDEEP
sql-server-2008ssis
Keith Adler
Keith Adler

Reputation: 21178

SSIS Bulk Insert Task from Format File

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?

Upvotes: 0

Views: 1634

Answers (1)

Randy Minder
Randy Minder

Reputation: 48402

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?

Upvotes: 3

Related Questions