Hi,
I have CRM 2013 on-premise installed on 64 bit machine, CRM APP Pool is allowed to execute in 64 bit mode only.
I have registered a plugin which executes SSIS package resided on file system. Following is a code I am using.
string PackageLocation;
Package Package;
Application App;
DTSExecResult Result;
PackageLocation = _SecureConfig;
App = new Application();
Package = App.LoadPackage(PackageLocation, null);
Variables Parameter = Package.Variables;
Parameter["User::var"].Value = context.PrimaryEntityId.ToString();
Result = Package.Execute(null, Parameter, null, null, null);
I have installed Microsoft.SQLServer.managedDTS and DTSRuntimeWrap into GAC to support DLLs in plugin. The CRM server in which plugin executes has already SSIS installed.
When I run plugin, I encountered something generic error and upon finding it from trace it was as following.
Microsoft.SqlServer.Dts.Runtime.DtsComException: An Integration Services class cannot be found. Make sure that Integration Services is correctly installed on the computer that is running the application. Also, make sure that the 64-bit version of Integration
Services is installed if you are running a 64-bit application
Can anybody please share some insights on what I can be doing wrong with ?
Thanks and regards,
Hiren Solanki.
Please vote or mark as a answer if it helped you.