How to TRUNCATE or empty a SQL Server table within SSIS Data Flow

Question

I do understand that I can simply add a TRUNCATE TABLE command inside an EXECUTE SQL TASK within my Control Flow, prior to calling my Data Flow. However, I want to do this within the Data Flow instead? There is a reason I want to do it this way I just don't want to get into the long explanation as to why. Has anyone ever done this?

Thanks in advance.

Answer 1

Hi @Scott Johnson ,

You may use OLE DB Command Transformation in Data Flow.

The OLE DB Command transformation runs an SQL statement for each row in a data flow. For example, you can run an SQL statement that inserts, updates, or deletes rows in a database table. I tested that it could also truncate the table.

ole-db-command-transformation

Regards，

Zoe

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October