Click here to Skip to main content
15,867,771 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I'm using SSIS to perform tasks on my db.
I want to delete all records of a table by using an Execute SQL task.
I inserted the Execute SQL task block on the Control flow designer from the SSIS Toolbox.

I don't know where I should edit the task and write my delete statement.

(When I created a Data flow task I could see a "Data Flow" menu option next to "Control flow", but now I don't have a "Sql task" window.)

What I have tried:

https://drive.google.com/file/d/1IW_5aLNT7ch8OajlEUyk3h2N6pQLqBEb/view?usp=sharing
Posted
Updated 11-Jan-21 4:48am

1 solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900