@Harshvardhan Medikonda Welcome to Microsoft Q&A platform and thanks for posting your question.
Can you try with this Solution, Selecting the option from Query to Non-Query made it work in the settings of Script Activity
Please don’t forget to Accept Answer
and Yes
for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.