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 ]: 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.
Screenshot of Error in SSIS package :
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.