Hi @Eng Soon Cheah ,
We can use Execute SQL Task to execute the sql query in ssis package.
Hope the following link and picture will be helpful:
Replacing a SQL Cursor with SSIS
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 in November--What can I do if my transaction log is full?
Hot issues in November--How to convert Profiler trace into a SQL Server table?