Setting up an SSIS job - VisualCron - Forum

Community forum

VincentK
2017-12-20T18:05:05Z
Hello all
I would like some assistance on setting up an SSIS task. I'm having a bit of confusion on what to enter in some of these fields.

In the Execute SSIS Package task screen, I've selected "Package Located In Database".
Under the Package Name, i put in the name of the package
Under the Datbaase ip/dns name option, I've got the database server
Under the Database Credential, I enter the login credentials.
This is in the screenshot

2017-12-20 09_56_50-dev_dwh - Remote Desktop Connection.jpg
When I run the job, this is the error message I get :

Unhandled error occured: Microsoft.SqlServer.Dts.Runtime.DtsPipelineException: Retrieving the COM class factory for component with CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following error: 80040154 Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)). ---> System.Runtime.InteropServices.COMException: Retrieving the COM class factory for component with CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E} 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 SSISExecute2005.SSIS2005.ExecutePackage(TaskSSISInfoClass task)
at MvtFWt22sTN5aFimi1.qlrThhJrBBmdS9X7v2.XhhSrBBmd(String[] )
Exception in Task: Unhandled error occured: Microsoft.SqlServer.Dts.Runtime.DtsPipelineException: Retrieving the COM class factory for component with CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following error: 80040154 Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)). ---> System.Runtime.InteropServices.COMException: Retrieving the COM class factory for component with CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E} 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 SSISExecute2005.SSIS2005.ExecutePackage(TaskSSISInfoClass task)
at MvtFWt22sTN5aFimi1.qlrThhJrBBmdS9X7v2.XhhSrBBmd(String[] )

Can someone assist?
Support
2018-01-10T15:09:09Z
Hi Vincent,

sorry for the late reply. Did you get this resolved through chat or email?

The problem seems to be that you have not installed Integration Services (from SQL server) on the VisualCron server.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Scroll to Top