can not run SSIS package with script task
Posted on 2013-10-29
I created an SSIS package using visual studio 2010 and tested on my local machine. It worked as expected.
Then I deployed this package on sql server 2012 Integration services under MSDB.
I connect to Integration services form SSMS on my local machine and execute the packeg by right click -> Run Package. I get the error on the script task as described below.
It works fine if I remove the script task, it has two sql tasks that run fine using oledb connection.
Error: To run SSIS package outside of data tool you must install <script task name> of Integration services or higher.
Now I remote into the server where Sql Server is installed and open SSMS on the remote machine. I execute the same SSIS package by right click ->Run package, and it runs without error .
What am I missing? What do need to do so the script task runs from remote machine.
Thank you for your help.