title: Error While executing a SSIS package which contains a script task through SQL Server SSISDB
body: <p>I have an SSIS project that contains foreach loop containers that get the files from a source folder, do the ETL, and then using Script Task i zip each file and then move it to an archive folder.<br/> The process runs with no issues when i execute it from visual studio. However, when i deploy it to SSISDB i get this error message: </p>
  
  <blockquote>
    <p>"Script Task: error exception has been thrown by the target of an
    invocation".</p>
  </blockquote>
  
  <p>When I go back to visual studio and disable the script tasks and deploy it again to SSISDB, it runs without any errors in SSISDB. </p>
  
  <p>Could it be that the SQL login doesn't have the permission to move and modify files? If so, how to solve this? </p>
  
  <p>Your help is so much appreciated.</p>