I am facing an odd problem,
I have an SSIS Package that runs import and export jobs, They were created in a different server and were moved to two different servers. In one of the servers its running fine but in another server it is giving me the following error.
"Error loading dtsImportLoadCapacity.dtsx: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D. An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80040E4D Description: "Login failed for user 'QAUser'."."
I have a configuration manager that stores all the sensitive details in a Table and fetches it from the table while run time and the package is "password protected".
The package is running successfully but i am getting the error also.
I have to move this package to another server too, I want to know whether it will be a problem if i move it to another server.
I have some three days to figure this out.
So kindly help me in solving this problem.