Hi @Pranvi Kanwar ,
1.Could you please share the version of the SSDT and SQL Server?
2.Please delete the Script Task and then recreate new Script Task.
3.Please check the TargetServerVersion in SSIS project.
Best regards,
Mona
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.