How to Delete Rows From Within an SSIS Data Flow
SQL Server Integration Services (SSIS) lets database administrators set up packages that run several steps. Each step contains a SQL statement or database element that manipulates data. Use the data flow to delete rows from within the SSIS package. You delete rows using the "delete" SQL statement, which permanently removes data from any table.
Other People Are Reading
Instructions
-
-
1
Click the Windows "Start" button on your database server or a computer that has access to the server. Type "sql management studio" in the search text box and press "Enter" to open the software.
-
2
Log in to your database server and click the database that contains the SSIS package. Right-click the package you want to edit and select "Modify."
-
-
3
Click the step you want to edit and click "Edit" to open the data. If you want to create a new step, click "New."
-
4
Type the delete statement in the editor to run the deletion procedure that removes rows. For instance, the following statement deletes all order records that are older than "11/11/2009":
delete from orders where order_date < '11/11/2009'
-
5
Click "Save" to save the changes. Click "Run" if you want to execute the package after the code changes.
-
1
