|
|
|
|
-
Nirav Gandhi Commented 2 Months ago through Ask | 10 Points
1)Take 2 data source one is SQL and another is ORACLE
2)take one data flow control
3)connect SQl data source to ORACLE and upload data to one Staging table
4)Compare this Data to original table and update flag against invalid data
5)Now i w...
|
-
Nirav Gandhi Commented 2 Months ago through Ask | 10 Points
i have try this but i got error.
thanks for u reply...
|
-
Nirav Gandhi Posted 2 Months ago through Ask | 10 Points
Dear All,I have 2 data source one is SQL and other is ORACLE Data source i am fetching data in oracle data source and insert in SQl table then i m running Some validation job for data,in SQl table i have one Error flag column to show error datanow i wan...
|
-
Nirav Gandhi Commented 5 Months ago through Ask | 10 Points
which type of ORACLE Provider ?
do u have website link for download this provider?
i m using SQl-2005...
|
-
Nirav Gandhi Posted 5 Months ago through Ask | 10 Points
How to connect Oracle-10g Database to SQL Server through SSIS or linkedserver?client server is required or not if required then any of person can you please send me a link of oracle-10g client software download link?...
|
-
Nirav Gandhi Replied 11 Months ago through ASK | 1 Point
ok thanks...
![]()
|
0
·
0% ·
0
|
|
|
|
-
Nirav Gandhi Replied 11 Months ago through ASK | 1 Point
but use above function..and try to do both give same result...
![]()
|
0
·
0% ·
0
|
|
-
Nirav Gandhi Commented 11 Months ago through Ask | 10 Points
but use above function..and try to do both give same result...
|