INCREMENTAL Load from Oracle Data Source in SSIS
Hi, I Want to run an incremental load for an oracle data source where in oracle i should pull the data using the logic SYSDATE -1, Can you please assist me how to do it in ssis.
June 30th, 2011 4:04am

I suggest to use a query in your source like select ... from table where dateintable = sysdate - 1
Free Windows Admin Tool Kit Click here and download it now
June 30th, 2011 4:14am

hey Crista Kurschat, 1. the data column i have in source has only date part with out time. When i compare it, does this SYSDATE takes only date part and compare directly with my date column or will it only accepts date time. 2.also i have some 9 million rows in my oracle source..So if i try to do incremental loan in ssis will there be any performance issues. because when in ran the dataflow for fullload in ssis it took me around 6 hours to load. Thanks in advance.
June 30th, 2011 4:25am

1. I'm not fit in Oracle SQL so I can't say anything about that 2. 9 million rows should not take so much time. What tasks do you have between source and destination? If you only load daily data should run much faster, if the indices in Oracle are set well.
Free Windows Admin Tool Kit Click here and download it now
June 30th, 2011 4:34am

Hey JUST confirm me one thing can i write the query as 1. select * from mytable where timecolumn = sysdate -1 in my oledb source sql command input area. 2. In the dataflow while loading the data from source it is taking long time. once the data in extracted from source it is not taking much time in transformations. What do you think might be the problem in this case. Thanks.
June 30th, 2011 4:42am

1. yes, you can. Change the Sourcetype to Query. 2. Should be an Oracle Issue, please ask your Oracle Admins
Free Windows Admin Tool Kit Click here and download it now
June 30th, 2011 4:55am

Thanks Christa. That was helpful.. Now, Can Any one please help me with the correct ORACLE query for retrieving the data in incremental loading in SSIS. 1. select * from mytable where timecolumn = sysdate -1 ( Please corret me if it is Wrong) As i said earlier i want only date part and neglect the time part in my case. Please let me know how to do this. Thanks in Advance.
June 30th, 2011 5:01am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics