I am trying to connect to an oracle view that has been provided for me utilizing SSIS with SQL Server 2008.
This uses the VISUAL Studio 2008 shell.
My first step was to create an Oracle ODBC Driver Configuration along with my tns names file. When I test the connection using the ODBC Data Source Administrator it is successful.
So what do I need to put on my machine now to get this to work in SSIS. I put both the win32 and 64 bit for 11g Release(11.2). I was told I needed both.
I still get an error.
I just uninstalled everything Oracle for the exception of my ODBC connection.
Please help. I am into about 4 business days on trying to make a simple connection and no luck so far.