Hello.
I have a SSIS task but I keep getting an error!
I tried:
- Located in package file: local path or network path on my server BDD
- Located in package database: my_db_server_name\MSDB\my_package_name
The error:
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. ---> System.Runtime.InteropServices.COMException (0x80040154): Retrieving the COM class factory for component with CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following error: 80040154.
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 mdOAdakHT6EQy0vOXC.rFVRu7wU0bDrYsSEHJ.XIUg0s8U1(String[] )
Exception in Task: Non zero exit code
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. ---> System.Runtime.InteropServices.COMException (0x80040154): Retrieving the COM class factory for component with CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following error: 80040154.
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 mdOAdakHT6EQy0vOXC.rFVRu7wU0bDrYsSEHJ.XIUg0s8U1(String[] )
Exception in Task: Non zero exit code
Should I install SQL Server Tools to the VC server?
thank you