July 16, 2013 at 2:10 am
Hi All,
I have got a situation where my SSIS package dumps Data from a SQl Server source to a Oracle Database which serves as Staging environment for another round of ETL.
My concern is for the SSIS - SQL Server to Oracle part.
There are some records which gets missing every other day, say roughly 2-3% of total records. The strange part is that when the package is rerun, the load finishes just fine loading all the records with zero misses.
I have also checked the records and there is nothing unusually wrong for the records that were loaded to the ones which weren't in first run.
I am not very sure on how to debug this scenario :w00t:
Any help offered would of great value to me. Thanks a lot in advance.
July 16, 2013 at 2:35 am
Anything special in the data flow? Lookups, conditional splits?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 16, 2013 at 2:51 am
What is there inthe dataflow? How are you handling error rows, are you writing them some where?Even there might be truncation of the data when converting from sql server to oracle
July 23, 2013 at 10:37 am
are you sure there isnt another process running in Oracle that is deleting the records (or perhaps locking the table)
Are you relying on a lookup table that is incomplete on the scheduled run
Are you using transactions (not sure how DTC - Distributed Transaction Control - works with Oracle)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply