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
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?
Edited by user
2017-12-20T18:09:51Z
|
Reason: fix image