FridayNightGiant (11/2/2016)
You haven't provided enough information to help. How are you determining the number of rows in the oracle table? What process are you using to move rows. Does the destination table already contain rows?
I connect via Visual Studio and at data flow tab, I create OLE DB Source (Oracle) and then connect to OLE DB Destination (SQL) directly
source ------> Destination
and the column already contain rows at Oracle and Sql.
When I using execute command from source Oracle Select * from
to Sql,
the result was different and too many double at destination table.
Is it necessary if I use look up ?
source ---> look up ---> destination