OracleClient requires Oracle client software version 8.1.7 or greater

I developed a loading script in 32 bit MS visual studio and the script running fine in Visual Studio. The script is about loading oracle data into MS SQL database.

I have 64 bit Windows 2008 R2 server with 64 bit MSSQL 2008 server

I created a MS SQL job to attach the loading script but the script is failed to run with the following error in job history

I don't understand why the script running fine in Visual Studio but when it attached to the MSSQL job and it ran failed.


Message
Executed as user: domain\login name. Microsoft (R) SQL Server Execute Package Utility  Version 10.0.4000.0 for 32-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  12:01:00 AM  Error: 2011-10-17 00:01:09.99     Code: 0xC0047062     Source: Load UnsubscribedEmails ADO NET Source [1]     Description: System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.     at System.Data.OracleClient.OCI.DetermineClientVersion()     at System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)     at System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions)     at System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)     at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)     at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)     at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)     at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)     at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)     at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)     at System.Data.OracleClient.OracleConnection.Open()     at Microsoft.SqlServer.Dts.Runtime.ManagedHelper.GetManagedConnection(String assemblyQualifiedName, String connStr, Object transaction)     at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManager100.AcquireConnection(Object pTransaction)     at Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter.AcquireConnections(Object transaction)     at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostAcquireConnections(IDTSManagedComponentWrapper100 wrapper, Object transaction)  End Error  Error: 2011-10-17 00:01:09.99     Code: 0xC0047017     Source: Load UnsubscribedEmails SSIS.Pipeline     Description: component "ADO NET Source" (1) failed validation and returned error code 0x80131500.  End Error  Error: 2011-10-17 00:01:09.99     Code: 0xC004700C     Source: Load UnsubscribedEmails SSIS.Pipeline     Description: One or more component failed validation.  End Error  Error: 2011-10-17 00:01:09.99     Code: 0xC0024107     Source: Load UnsubscribedEmails      Description: There were errors during task validation.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  12:01:00 AM  Finished: 12:01:10 AM  Elapsed:  9.39 seconds.  The package execution failed.  The step failed.


I spent a lot of time trying to fix this issue. But all failed. Please help. it's kind of urgent