Hi, I was having problems connecting to Oracle in a SSIS package that I scheduled in SQL Server 2008 R2 Agent. To fix the problem,I enabled "Use 32 bit runtime" in the execution option and it's been working since then. This was on my Test server. I have now moved the package to my production environment with the same spec as my Test but I'm getting the error below: 0.50.1600.1 for 32-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 13:46:21 Error: 2011-05-19 13:46:25.19 Code: 0xC0202009 Source: IFS_Master Connection manager "IFS" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x8007007E. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x8007007E Description: "The specified module could not be found.". End Error Error: 2011-05-19 13:46:25.20 Code: 0xC00291EC Source: Obtain IFS Last Update Flag Execute SQL Task Description: Failed to acquire connection "IFS". Connection may not be configured correctly or you may not have the right permissions on this connection. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 13:46:21 Finished: 13:46:25 Elapsed: 3.359 seconds. The package execution failed. The step failed. All the resources I've seen on the internet have not helped. I'd be grateful if you can help with this. Thanks, Cognitics

Please don't post a new question in the FAQ thread. Start a new thread. The error message reported by your execution indicates that some part of the driver associated with your connection manager named "IFS" can't be used. I'm assuming this IFS connection uses some sort of an Oracle driver to communicate to a server. If so, you need to verify that this driver and connection are configured correctly - identically to your test environment. Talk to me now on

Hi, check the execution permission of the user for this package. Thanks Ayyappan Thangaraj UG Lead, Puducherry, http://SQLServerRider.blogspot.com

Please check SQL Agent Service account have enough permissions on package and folders which its accessinghttp://uk.linkedin.com/in/ramjaddu