I'm trying to access at one of the corporate database of my company using the Attunity Connector. The database is probably based and build in United State with their currency format of currency and datetime. The database is probably on Oracle 10 or 11G.
I have a Windows Server 2008 64bit with Microsoft SQL Server 2012 BI Edition. I have also Oracle Instant Client 11G 32 and 64bit installed. The Windows Server 2008 is Canadian French however I have modified the currency and the datetime information in Windows to be in American format. I have also modified the NLS_Lang to be in AMERICAN_AMERICA.AL32UTF8. I also have installed the Attunity Oracle Connector 2.0 for .NET.
I am trying to gather the data using SSIS to push them to my SQL Server Database.
I have verified if my connection to the database is successful using the Oracle SQL Developper. I had the exact same error ORA-01843 before in SQL Developper before I added in the sqldevelopper.conf the line : AddVMOption -Duser.language=en
The problem is when I'm tying to make my connection with SSIS using any .NET oracle Connector to a view who contain date, I always have the same error, the same I used to have before I've modified SQL Developper to be in english saying that it's not a valid month.
I don't know if anyone had face this error and knows a work around or if anyone knows to modified the .NET Dateformat.
Thanks for help !
