Hi,
we installed VC version 5.7.3 on own server Windows 2k3 R2, we need run a dtsx locally to import a txt file in a SQL 2005 database on another server; we want to do that because we would like to know if it is possible capture dtsx error code.
Infact if we use the SQL Task function in VC we can't receive any return error code because (we know after read an old topic here) VC run only the task.
Running the task "Execute DTS Package" from VC we receive in output the follow message: Exception in Task: Retrieving the COM class factory for component with CLSID {10020202-EB1C-11CF-AE6E-00AA004A34D5} failed due to the following error: 80040154.

Could you please help us?
Thank you.

Hi,

is the MSSQL 2005 32 or 64 bit?

---

Have you tried the SSIS Task for this?

---

I used to have the same exact error in previous version, but in version 5.7.3 when using the SSIS task (Not DTS) it works very well. One question i have is with the SSIS package, how does it run when i have a password encrypted?

Thank you for your reply, I reply to your questions:

a) MSSQL is a 64bit engine;
b) I didn't tyr SSIS package

I will try with SSIS package and I will update you.
Thank you again.
Cristiano

I used to have the same exact error in previous version, but in version 5.7.3 when using the SSIS task (Not DTS) it works very well. One question i have is with the SSIS package, how does it run when i have a password encrypted?

The SSIS Task has a text field for package password. Have you tried that?

---

Yes, it said the password was wrong...I run that type of DTSX package through a command line and it requires the DECRYPT Argument before the password.

Error: -1073659809,Failed to decrypt an encrypted XML node because the password was not specified or not correct. Package load will attempt to continue without the encrypted information.


The SSIS Execution failed

Number of warnings: 0
Number of errors: 5
Error (0):SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D.
An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80040E4D Description: "Login failed for user 'klewis'.".

Error (1):SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "MBHQSQL12,5605" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.

Error (2):component "Header" (566) failed validation and returned error code 0xC020801C.

Error (3):One or more component failed validation.

Error (4):There were errors during task validation.

From, GetErrorValues (0)


Exception in Task: Non zero exit code
Exception in Task: Error: -1073659809,Failed to decrypt an encrypted XML node because the password was not specified or not correct. Package load will attempt to continue without the encrypted information.


The SSIS Execution failed

Number of warnings: 0
Number of errors: 5
Error (0):SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D.
An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80040E4D Description: "Login failed for user 'klewis'.".

Error (1):SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "MBHQSQL12,5605" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.

Error (2):component "Header" (566) failed validation and returned error code 0xC020801C.

Error (3):One or more component failed validation.

Error (4):There were errors during task validation.

From, GetErrorValues (0)


Exception in Task: Non zero exit code

Yes, it said the password was wrong...I run that type of DTSX package through a command line and it requires the DECRYPT Argument before the password.

Are you using MSSQL 2005 or 2008? And 32 or 64 bit?

---

2008 and not selecting the 32 bit option...the package was created in 32 bit and running from a 32 bit Windows 2003 server. I have all the other SSIS packages set not to run in 32 bit also and they run fine.

2008 and not selecting the 32 bit option...the package was created in 32 bit and running from a 32 bit Windows 2003 server. I have all the other SSIS packages set not to run in 32 bit also and they run fine.

Not selecting it? Are you saying that this part does not work as expected?

---

Same result when i select 32bit mode.

Same result when i select 32bit mode.

Ok, I see, it makes sense. It will only make a difference if system is 64 bit.

---

Ok,

could you try to replace the installation files with the ones in this package. I am talking about overwriting the contents in the folder MSSQL2008 in the VisualCron installation folder.

Then run in unselected 32 bit mode.

EDIT: And, you need to stop the VisualCron service before overwriting the files.

---

All SSIS Jobs ran but just hung.

All SSIS Jobs ran but just hung.

Did the SSIS job ran in the database or not?

---

Thank you for your reply, I reply to your questions:

a) MSSQL is a 64bit engine;
b) I didn't tyr SSIS package

I will try with SSIS package and I will update you.
Thank you again.
Cristiano

Hi tried to run the DTSX locally like SSIS package but VC reported the follow 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 f00sk7c7nLMPuI2Lm6.ZVrGbjrr8433HBMRVa.eaimqBS0X(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 f00sk7c7nLMPuI2Lm6.ZVrGbjrr8433HBMRVa.eaimqBS0X(String[] )
Exception in Task: Non zero exit code

Do I have to run the DTSx in 32 bit mode?
Thank you.
Cristiano

Thank you for your reply, I reply to your questions:

a) MSSQL is a 64bit engine;
b) I didn't tyr SSIS package

I will try with SSIS package and I will update you.
Thank you again.
Cristiano

Hi tried to run the DTSX locally like SSIS package but VC reported the follow 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 f00sk7c7nLMPuI2Lm6.ZVrGbjrr8433HBMRVa.eaimqBS0X(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 f00sk7c7nLMPuI2Lm6.ZVrGbjrr8433HBMRVa.eaimqBS0X(String[] )
Exception in Task: Non zero exit code

Do I have to run the DTSx in 32 bit mode?
Thank you.
Cristiano

Please try.

---

Thank you.
I tried but I received this 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 f00sk7c7nLMPuI2Lm6.ZVrGbjrr8433HBMRVa.eaimqBS0X(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 f00sk7c7nLMPuI2Lm6.ZVrGbjrr8433HBMRVa.eaimqBS0X(String[] )
Exception in Task: Non zero exit code

If I run the DTSx from SQL2005 Scheduler it runs, obviously.
Thanks.
Cristiano

lionsgarden: Have you installed the Integration services from the 2005 sql cd?

---

No, thank you for suggestion.... 😊
If I install Integration service on my non-sql 2005 server, Will I able to capture the task output if it fails?
Thank you.
Cristiano

No, thank you for suggestion.... 😊
If I install Integration service on my non-sql 2005 server, Will I able to capture the task output if it fails?
Thank you.
Cristiano

Not sure if it will work on the remote server. I think it will only work on local. (limitation of dts packages)

---