This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 82%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERL%3C/text%3E%3C/svg%3E)
Dear All,
we developed SSIS packages for SQL server 2016 in visual studio 2016, now we are upgrading the sql server from 2016 to 2022 CU2 version. when we replaced the script components which contains C# code in all SSIS packages and deployed in Sql Server 2022 causing the below error
ERROR:
The binary code for the script is not PREFERENCES found. Please open the script in the designer by clicking Edit Script button and make sure it builds successfully.
Below are the things which we tried
a) Replacing the script components which are causing issue with new components
b) Rebuilding the script components
we are trying the solution for several days. Nothing is working
Please help in finding the solution for this issue
Configuration Details:
Microsoft SQL Server Data Tools for Visual Studio 2017 Version 15.9.52
Microsoft SQL Server Integration Services Designer Version 15.0.2000.180
VisualStudio.15.Release/15.9.52+33403.129
Microsoft .NET Framework Version 4.8.04084
BimlExpress 1.0
BimlExpress is a Visual Studio extension for editing and building Biml files.
C# Tools 2.10.0-beta2-63501-03+b9fb1610c87cccc8ceb74a770dba261a58e39c4a
C# components used in the IDE. Depending on your project type and settings, a different version of the compiler may be used.
Common Azure Tools 1.10
Provides common services for use by Azure Mobile Services and Microsoft Azure Tools.
NuGet Package Manager 4.6.0
NuGet Package Manager in Visual Studio. For more information about NuGet, visit http://docs.nuget.org/.
Project 1.0
Information about my package
ProjectServicesPackage Extension 1.0
ProjectServicesPackage Visual Studio Extension Detailed Info
ResourcePackage Extension 1.0
ResourcePackage Visual Studio Extension Detailed Info
ResourcePackage Extension 1.0
ResourcePackage Visual Studio Extension Detailed Info
SQL Server Analysis Services 15.0.19623.0
Microsoft SQL Server Analysis Services Designer Version 15.0.19623.0
SQL Server Data Tools 15.1.62002.01090
Microsoft SQL Server Data Tools
SQL Server Integration Services 15.0.2000.180
Microsoft SQL Server Integration Services Designer Version 15.0.2000.180
SQL Server Reporting Services 15.0.19528.0
Microsoft SQL Server Reporting Services Designers Version 15.0.19528.0
SsmsVsIntegration 1.0
Information about my package
Visual Basic Tools 2.10.0-beta2-63501-03+b9fb1610c87cccc8ceb74a770dba261a58e39c4a
Visual Basic components used in the IDE. Depending on your project type and settings, a different version of the compiler may be used.
Visual Studio Code Debug Adapter Host Package 1.0
Interop layer for hosting Visual Studio Code debug adapters in Visual Studio
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Please edit your question, and add the following:
@Yitzhak Khabinsky Added the configuration details
Hi @Raghuvamsi Lvs ,
Please try the method provided by Yitzhak Khabinsky to see if it is helpful.
I would suggest the following combination:
https://marketplace.visualstudio.com/items?itemName=SSIS.SqlServerIntegrationServicesProjects
I am not able to find 4.4 version of SSIS extension. Can you please provide link to download the 4.4 version.
we tried downloading 4.4.2 version and verified and still getting same issue as mentioned above