I am running package from my local system through Visual studio, It is running perfectly, even I created job and ran the job it is running fine
but when I have deployed my packages into production Sql Server and I am using Configuration File & running package from Job. 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.
"[EXL SRC ] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager_PAM" 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.
I got this ans which is applicable when running package from Visual Studio.
Ans when running from Visual Studio:
Go to Project Properties->Configuration properties-&g
View Complete Post