CRM 2013 (64 bit ) Plugin : Call SSIS package from file RRS feed

  • Question

  • 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.

    Tuesday, February 4, 2014 7:06 AM