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.
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  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