AcquireConnection method call to the connection manager “Entities” failed with error code 0xC0202009 error in SSIS package

Hi, I was creating SSIS package to upload data for an entity in CRM 2016 instance – Excel to CRM.  When I tried to execute data flow task, I came across with one weird error.  See the below details :

Error details :

Error at Create Entities[Get Classifications [249]]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager “Entities” failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.

Error at Create Entities[SSIS.Pipeline]: Get Entities failed validation and returned error code 0xC020801C.

Error at Create Entities[SSIS.Pipeline]: One or more component failed validation.

Error at Create Entities: There were errors during task validation.

(Microsoft.DataTransformationServices.VsIntegration)

Screenshot of Error in SSIS package :

Solution :

I noticed that Excelsheet was opened in the system so that the connection was not established with it. So we need to close the file when we  execute the data flow task. When I had closed the excel sheet then task run successfully. That’s All.

Thanks

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s