How to empty my destination table before inserting new records in SSIS?

sql-server database ssis relational-database
Tassisto picture Tassisto · Nov 27, 2013 · Viewed 85k times · Source

I use SSIS to generate and transform new data for later use in a new system. I have a problem every time I run my SSIS Package, it keeps inserting new records to my destination tables.

How can I empty my destination table (/OLE DB Destination) first and then inserting the newly generated records?

Currently the workaround for this problem is performing a delete from DestTable before running my package.

Answer

TsSkTo picture TsSkTo · Nov 27, 2013

Put your delete statement in an Execute SQL Task. Then make it the first component of your flow. The component looks something like this:

enter image description here

Related questions

How do I create a step in my SQL Server Agent Job which will run my SSIS package?

I'm trying to create an automated job for the SQL Server Agent to run. The job is supposed to run my SSIS package. Here's what I have so far: EXEC sp_add_job @job_name = 'My Job' ,@description = 'My First …

Read More
Reset identity seed after deleting records in SQL Server

I have inserted records into a SQL Server database table. The table had a primary key defined and the auto increment identity seed is set to “Yes”. This is done primarily because in SQL Azure, each table has to have …

Read More
How do I list all the columns in a table?

For the various popular database systems, how do you list all the columns in a table?

Read More