November 1, 2016 at 10:27 pm
Dear all,
Kindly need advice..
I want to dts table from oracle to sql with ssis.
Total 302 rows.
when the job is completed, the total rows are not the same between the data source and data destination.
Data source = 302 rows
data Destination = 91506 rows
:crazy: ??
November 2, 2016 at 1:41 pm
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?
November 2, 2016 at 9:21 pm
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply