1

I am getting the following error in SSIS Script task (SSIS 2015)

Adding Data to var:Error: The binary code for the script is not found. Please open the script in the designer by clicking Edit Script button and make sure it builds successfully.

Did some online research and made sure to do the following based on my search results:

  1. Delay Validation has been set to true
  2. Build has been set to x86
  3. We need this script to run on 32 bit compiler

Fails when executed as a deployed package on SQLServer (SSMS) Integration Services Catalogs (not as a job)

Howard Chen
  • 11
  • 2
  • I take it, when you go into the script task, it does build correctly? – Alan Waage Apr 14 '17 at 15:52
  • correct, everything works perfection when i build locally – Howard Chen Apr 14 '17 at 16:16
  • Is the SSIS package set as the same SQL server version as the server it is running on? – Alan Waage Apr 14 '17 at 16:17
  • SSIS: 2015, SQLServer: 2014 – Howard Chen Apr 14 '17 at 18:39
  • So if this runs fine locally, how does it fail? When run as a job? Please add more detail – Nick.Mc Apr 14 '17 at 23:18
  • No, not the VS version. What SQL server version is the SSIS built as? They have to match. Previous to VS 2015, it was hard-wired and you have to use the corresponding version of VS that matched your SQL Server. Starting in VS2015 you can select it. Goto the project properties > Configuration properties > General. make sure you are targeting SQL Server 2014 – Alan Waage Apr 17 '17 at 14:26
  • The SSIS is build with SQLServer version is 2012, but the SQLServer itself is 2014 – Howard Chen May 12 '17 at 18:25
  • Sorry, I should say that the SSIS build target version is 2012. SQLServer version is 2014. However, when i go to services.msc, I see that MsDtsServer110 is running, which indicates the SQL Server Integration Services version is 2012 – Howard Chen May 14 '17 at 18:51

0 Answers0