Hi, I have a ssis package which is running successfully from ssis server after importing into intergrations services server(deployment), but when I ran it as job its giving the following error message. The package is running successfully in local machines as well. My package is getting the data from DB2 servers using OLE DB provider for DB2. Find the error message below. Code: 0xC0202009 Source: sample Connection manager "<connectionName>" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040154. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered". End Error Error: 2010-12-16 23:55:12.72 Code: 0xC020801C Source: <Data flow task name> Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "<connectionName>" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call ... The package execution fa... The step failed.Sateesh Maduri

Hi. You have installed the DB2 provider on server?Vctor M. Snchez Garca (ES) (BI) Hope this help. Please vote if you find this posting was helpful. if this is an answer to your question, please mark it. http://bifase.blogspot.com | http://twitter.com/atharky

I would recommend running through a few of the points listed here http://blogs.lessthandot.com/index.php/DataMgmt/DBAdmin/ssis-runs-in-bids-but-not-with-sql-agent as well as Victor's suggestion on ensuring the DB2 providers are on the boxTed Krueger Blog on lessthandot.com @onpnt on twitter Please click the Mark as Answer button if a post solves your problem!

But its running on the same server after importing into ServerName(Integration services) -> Stored Packages -> MSDB -> package name.Sateesh Maduri

Hi, The SQL Agent execution account have permissions on MSDB? or the Proxy Account if you're are using some different. If the have configured the credentials on Connection Manager as Integrated, the SQL Agent must have access to data source. From MSDN:http://msdn.microsoft.com/en-us/library/cc627376.aspx This message might appear because of one of the following problems: The connection string specifies a provider that is not supported. You do not have the correct permissions to use SQL Server Agent to run the package. You do not have access to the specified data source. The specified data source is not available for a variety of reasons, depending on the type and location of the data source. For example, a data source might not be available for the following reasons: The network is not operating. The server is not available. Another application is using the data source file. The connection manager is configured to use SQL Server Authentication, but the package configuration file does not contain the needed password. Víctor M. Sánchez García (ES) (BI) Hope this help. Please vote if you find this posting was helpful. if this is an answer to your question, please mark it. http://bifase.blogspot.com | http://twitter.com/atharky