CODEWITHSUNDEEP
c#ssis
user1781830
user1781830

Reputation: 719

SSIS package falied c#

These are the errors that I encountered when calling a SSIS package on asp.net

SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft Access Database Engine" Hresult: 0x80004005 Description: "Could not find installable ISAM.". SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. component "Excel Source" (1) failed validation and returned error code 0xC020801C. One or more component failed validation.

Any recommended solutions to this?

Upvotes: 0

Views: 3060

Answers (1)

Ryan
Ryan

Reputation: 3982

This may be of some help:

Have you set DelayValidation Property of Data Flow Tasks to TRUE in your SSIS package? For more information about the error, please see the following article:

http://blogs.msdn.com/b/ramoji/archive/2009/03/10/the-acquireconnection-method-call-to-the-connection-manager-failed-with-error-code-0xc0202009.aspx

Upvotes: 0

Related Questions