All geek questions in one place

Delete or delete rows in the SIS package destination table

I used the import / export wizard in sql server 2005 management studio to export rows from an excel sheet to sql table and checked the "Do not delete rows in destination table" option. I saved the export operation as a ssis package, and yes new rows are added to the existing ones, but now I have a requirement to delete all rows in the destination sql table.

When I go to BIDS to edit my package, I cannot find a way to change this behavior anywhere. Does anyone know how to change this ssis package designer setting?

+3
source share
1 answer

, Flow " SQL". TRUNCATE TABLE . , , . Execute SQL Task . Execute SQL Task SQL "TRUNCATE TABLE [yourdestinationtable]"

+3

Source: https://habr.com/ru/post/1706709/

More articles:


All Articles