Hi , I am getting the following error when I am running a SSIS package from SQL Server agent job, But I could able to run the package from VS in development environment and also able to run successfully from Intergration server after importing the package into servername(Integration Services) -> Stored Packages -> MSDB-> package name. Please find the full error below.. and please help me asap. Package execution failed with [Error] : component "sample" (1) failed validation and returned error code 0xC020801C. Package execution failed with [Error] : SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "<somename>" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. Package execution failed with [Error] : One or more component failed validation. Sateesh Maduri

this is most likely a proxy permissions issue. if you are using a proxy account then you might want to check that if you run the package with DTExec while logged in as the proxy account that it does or doesn't work. If it doesn't then it is a permissions problem on the proxy account. If you don't have a proxy then you would need to check the permissions on the agent account since I believe that is what is used if there is no proxy. one question:: are you working on 32-bit machine?? Let us TRY this | My Blog :: http://quest4gen.blogspot.com/

The deployment server has both 32bit and 64 bit sql server versions, so I tried to run the package using operating system command(Cmdexec) but its failed with same error mentioned above. I used the following command in the job step. "D:\Program Files\Microsoft SQL Server (x86)\90\DTS\Binn\dtexec.exe" /DTS "\MSDB\packagename" /SERVER servername /DECRYPT welcome /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING VSateesh Maduri

Hi, Are you using any file connection manager?

I am using IBM OLE DB Provider for DB2 which gets the data from DB2Sateesh Maduri

hmmmm are SSIS Server and SQL Server Agent on the same machine?

Yes, both are on the same machine Sateesh Maduri

Try creating a proxy account and run the job unber proxy account. Which worked for me. --Anju_2

Do you have any detailed information like how to create proxy account and required permissions for proxy account.Sateesh Maduri

Do you have any detailed information like how to create proxy account and required permissions for proxy account.Sateesh Maduri

Do check this demo for the detailed step of creating account: http://msdn.microsoft.com/en-us/library/dd440760.aspx