My setup: Windows Server 2003 x64 Oracle Client 11g 32-bit Oracle Client 11g 64-bit Attunity Oracle Connector x64 The SSIS package runs good in VS2008. But when I run the package inside a SQL job I get the following error: Started: 1:43:57 PM Error: 2011-03-21 13:43:58.16 Code: 0x000002C0 Source: xxx Connection manager "Oracle Connector 1" Description: OCI error encouneterd. End Error Error: 2011-03-21 13:43:58.16 Code: 0x0000020F Source: Data Flow Task 1 Oracle Source [1] Description: The AcquireConnection method call to the connection manager Oracle Connector 1 failed with error code 0x80004005. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error Error: 2011-03-21 13:43:58.16 Code: 0xC0047017 Source: Data Flow Task 1 SSIS.Pipeline Description: component "Oracle Source" (1) failed validation and returned error code 0x80004005. End Error Error: 2011-03-21 13:43:58.16 Code: 0xC004700C Source: Data Flow Task 1 SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2011-03-21 13:43:58.16 Code: 0xC0024107 Source: Data Flow Task 1 Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 1:43:57 PM Finished: 1:43:58 PM Elapsed: 0.625 seconds. The package execution failed. The step failed.

And has the user that runs the package the correct authorization? Other interesting forum threads: http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/ab662d63-6385-4f73-b27f-d526048f601f/Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

Does sql server agent service account have enough permissions on the SSIS package folders?