sorry - I don't have any more suggestions other than trying the alternative Jo Pattyn suggested

http://www.sqlservercentral.com/Forums/Topic1077381-1044-1.aspx

something like

to_char(QD_RDB_ENTRY_DATE, 'yyyy-mm-dd 'HH24:MI:SS.FF7')

you might have to remove the 24 from the HH portion depending on how the instance of oracle is configured

Sql Server datetime2(7) is the largest fractional seconds...

the correct file name for the 32 bit 11g release 1 is win32_11gR1_client, which is version (11.1.0.6.0)

according to Microsoft you do, if you want both to develop and to run SSIS packages on a 64-bit computer:

http://msdn.microsoft.com/en-us/library/ee470675(v=sql.100).aspx

gee golly - what has Oracle done -

Looks like they are pushing the "Oracle Data Access Components (ODAC) for Windows"

http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html

This might be an option, but I have not...

Sorry, can check these during the day from work -- not allowed . . .

The Oracle Universal Installer does not have a Drop Down Box where you can specify the...

Didn't you have to specify in the PATH Variable the location of the installation for both the 32 bit & 64 bit install?

No - not on a Windows 2008 R2...

These are the versions I installed

11g R1 32 bit

11g R2 64 bit

Yes, had to remove registry entries and directories during the process.

No notes on the uninstall or registry...

the error is expected when installing the 64 bit client second - just click continue

I have step by step screen shots I can send via email

- it took me...

1st Install Oracle 11g R1 32 bit – Custom

change Name to end with home2

Change path to end...

I found Jorg Klein blog very helpful

http://sqlblog.com/blogs/jorg_klein/archive/2011/06/09/ssis-connect-to-oracle-on-a-64-bit-machine.aspx

Perhaps one of these links will provide what you need

http://www.sqlservercentral.com/Forums/Topic986027-392-1.aspx

http://www.sqlservercentral.com/scripts/Maintenance/90468/

link that states "In this release, only versions of projects are supported in this view."

http://msdn.microsoft.com/en-us/library/ff878005.aspx

change the ProtectionLevel to "DontSaveSensitive"

good to know!