A script task is not functioning as expected at runtime in SQL 2017,and it's working fine on SSIS package local

Question

A script task is not functioning as expected at runtime in via SQL 2017 batch job, it's working fine on SSIS package locally and gives me expected result.

When it works well with the same package and configuration as before, it has not worked since Deploy.

Versions : VS2015 &VS 20016 ,SSMS 2017

Please help!!

Answer 1

Hi @Roahn K ,

When you run it in SQL 2017, is there any error message?

Manually delete all the files possible in C:\Users\XXX\AppData\Local\Temp.

And then open the script editor to see if it complains any error in your code.

After that, build it and save your script. Remember to click ok in the script editor.

Redeploy the project to SQL Server and run in the agent job for a try.

You may also copy the script to a new SSIS project, re-build and re-deploy for a try.

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

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.

Answer 2

A script task is not functioning as expected at runtime in SQL 2017,and it's working fine on SSIS package local
A script task is not functioning as expected at runtime in via SQL 2017 batch job, it's working fine on SSIS package locally and gives me expected result.

When it works well with the same package and configuration as before, it has not worked since Deploy.

Versions : VS2015 &VS 2017 ,SSMS 2017

Please help!!