I am working on an SSIS package using SQL Server 2012 and the Visual Studio 2010 shell.
I need to use the web method in the script task that I have, and I was able to run this script on Windows 7 without any problems. This web service requires a certificate that I installed in my store.
However, when I migrated this project to Windows Server 2008 R2, the package terminated, apparently for no reason. I do not have compilation errors in the error list, and if you create a script task, it will be successful, however, when I finish editing the script, a message appears with this error message:
"The scripts contained in the package have compilation errors. Do you want to save the changes?"
If I remove the web link from the script task, this message will not appear.
The package will not start because of this. I checked the error data in the event viewer, but it only shows the "Error Package" and there is no detailed information about this problem. Could this be due to a certificate issue? Is there an error log or a way to find out more about what causes a packet to fail?
Thank.
source
share