Greetings - I hope this is the right place to get an answer to one crazy issue I have.
I am trying to set ODAC and Visual Studio to work properly; I am using Visual Studio 2010 and trying to setup a simple SSIS package to extract data from an Oracle database table into a SQL database table.
I installed ODAC drivers for x32 and x64, I can create the package that runs and executes. The issue is that it will not reflect any changes in the source table in Oracle; for example, if I have 100 records in Oracle table at the initial run of SSIS package it will bring all the correct records over into SQL.
Let's say I refresh the oracle table and now I have 500 records - the SSIS package still brings over 100 records. So I guess some kind of caching ...
I tried installing and re-installing the drivers and no luck. Just drives my crazy - tried any version of Visual Studio; even Atuity connectors provided by Microsoft.
Any help will be appreciated.
Thank you!
AV