I tried running from command prompt from both 32 bit(Program Files(86) and 64 bit Program Files folders.

Job fails in both

64 bit Error -

Started: 1:02:54 PM

Progress: 2012-08-14 13:02:58.03

Source: Load Audit_Log

Validating: 0% complete

End Progress

Progress: 2012-08-14 13:02:58.05

Source: Load Audit_Log

Validating: 50% complete

End Progress

Error: 2012-08-14 13:02:58.50

Code: 0xC02020F6

Source: Load Table_Name SourceDB Table_Name Source [1]

Description: Column "Column_Name" cannot convert between unicode and non-u

nicode string data types.

End Error

Error: 2012-08-14 13:02:58.52

Code: 0xC02020F6

Source: Load Table_Name SourceDB Table_Name Source [1]

Description: Column "Column Name" cannot convert between unicode and non-unicod

e string data types.

End Error

32 bit Error -

Error code: 0x80004005.

An OLE DB record is available. Source: "OraOLEDB" Hresult: 0x80004005 Descrip

tion: "ORA-12154: TNS:could not resolve the connect identifier specified".

End Error

Error: 2012-08-14 13:07:03.76

Code: 0xC020801C

Source: Load Table Name SourceTable Name Source [1]

Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAG

ER. The AcquireConnection method call to the connection manager "Source" fai

led with error code 0xC0202009. There may be error messages posted before this

with more information on why the AcquireConnection method call failed.

End Error