Get following Error when Loading the SSIS Package using C# Code

indian143

Hi, I am getting the following error when I am trying to load SSIS Package using C# code:

Microsoft.SqlServer.Dts.Runtime.Package, ErrorCode : -1073676264, Description : Error loading value "6" from node "DTS:Property".
, SubComponent: , HelpFile, HelpContext0, IdofInterfaceWithError

I got this error through the Event Listener I passed into the Load method call. This code was working before but suddenly stopped Working. The changes that happened in this mean time are, I needed to change my laptop, as it is new Laptop I needed to install all Software, some of them I installed online Evaluation versions like SQL Server 2008 R2 and 2012 because they were not available in there. Here is the code that I used to load the Package from FileSystem:

if (!string.IsNullOrEmpty(PackagePassword))
{
_app.PackagePassword = PackagePassword;
}

                        //DTSEventListner eventListner = new DTSEventListner();
                        \_Pkg = \_app.LoadPackage(packageFullPhysicalPath, Listerner);
                        \_PkgLocation = packageFullPhysicalPath;
                        \_Status = DTSPackageStatus.Loaded;

Any help would be very helpful. Thanks in advance. Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."

Richard Deeming

PackageFormatVersion 6 suggests the package was created for SQL 2012. Are you trying to load it with SQL 2008 R2, or using the 2008 R2 libraries?

"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

indian143

But now I have installed SQL Server 2012, is it because of .Net version or SQL Server Version I have installed SQL Server 2016 first then installed 2009 R2 but now I uninstalled 2016 but installed the 2012 from online Evaluation version thinking I will apply the key from company after Package starts working. Did I do anything wrong, any help would be greatly helpful thanks my friend. It bothers more when a thing starts working and then stops. Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."

indian143

Hi Rick, I am getting the following Warnings, is this something can be helpful for me, any advice would be very helpful my friend. Thanks my friend.

Severity Code Description Project File Line Suppression State
Warning There was a mismatch between the processor architecture of the project being built "MSIL" and the processor architecture of the reference "Microsoft.SQLServer.DTSRuntimeWrap, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91, processorArchitecture=x86", "x86". This mismatch may cause runtime failures. Please consider changing the targeted processor architecture of your project through the Configuration Manager so as to align the processor architectures between your project and references, or take a dependency on references with a processor architecture that matches the targeted processor architecture of your project. EncryptDecryptSecretStrings

Warning There was a mismatch between the processor architecture of the project being built "MSIL" and the processor architecture of the reference "Microsoft.SQLServer.DTSRuntimeWrap, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91, processorArchitecture=x86", "x86". This mismatch may cause runtime failures. Please consider changing the targeted processor architecture of your project through the Configuration Manager so as to align the processor architectures between your project and references, or take a dependency on references with a processor architecture that matches the targeted processor architecture of your project. FileWatcherScheduleApp

Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."

Richard Deeming

That suggests it's a 32/64-bit issue. You need to change your project to target "x86" instead of "Any CPU". How to: Configure Projects to Target Platforms[^]

"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

indian143

Its nice to do it but what if I deploy the code in Production and there if its different OS or different version of OS like 32 bit or 64 bit etc. Should I ignore this as it is Warning only because if it messes in the Server its going put me into more troubles. Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."

Richard Deeming

If you're referencing a 32-bit assembly, you don't have a choice; you have to target x86. A 64-bit OS won't have any problems running a 32-bit application.

"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

indian143

Thanks my friend :) Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."