I would give you a rather simple solution which can do the truncate in a single query single step.
Get the list of tables to truncate comma separated using lookup / parameter etc.
pipeline().parameters.tables = 'my_table1,my_table3,my_table3'
Create Truncate query by replacing , with ; TRUNCATE TABLE
query = @concat('TRUNCATE TABLE ', replace(pipeline().parameters.tables, ',', ' CASCADE; TRUNCATE TABLE '), ' CASCADE;')
Run the query using an activity of your choice, eg. lookup.
I am using this approach for SQL Sever. I am kind of confident that it will work everywhere.