I have deployed my packages into Sql Server and I am using Configuration File. AsÃÂ my Data Source is Excel, I have changed the connection string during deployment with Server Path. But I am getting the following errors. Actually the File Exist in Path. May I know What is cause of the issue? Do I need to give any permission to execute the package.
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 Service Contract Upload" (1) failed validation and returned error code 0xC020801C.ÃÂ
One or more component failed validation.ÃÂ
There were errors during task validation.ÃÂ
DTS_E_OLEDBERROR, Error Code: 0x80004005 Source: "MS JET DB Engine" Description : Path is not valid
View Complete Post