Hi,
I have a job with SSISDB package task, SSIS package is located on remote SQL server Integration service catalog db. I am getting following error when I run the job.
Unhandled error occured: 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. ---> System.Runtime.InteropServices.COMException: Retrieving the COM class factory for component with CLSID {5572B772-88AC-4A35-96F8-E28626AC7E8F} failed due to the following error: 80040154 Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)).
at Microsoft.SqlServer.Dts.Runtime.Application..ctor()
--- End of inner exception stack trace ---
at Microsoft.SqlServer.Dts.Runtime.Application..ctor()
at SSISExecute2012.SSIS2012.ExecutePackage(TaskSSISInfoClass task)
at pGvDqEr2sD5WwJo1O5.aKjv0KZiixFJw1av49.z0KkiixFJ(String[] )
From some other thread in the forum, I see that it is suggested to install Integration services on the visualCron server to resolve the issue. I have SQL Express 2014 with basic integration services on the visualcron server. Let me know what features of integration services required to run SSISDB task.
Thanks,
Madhusudan.