May 30, 2013 at 1:52 pm
Hi friends,
I have following issue:
I have one table called customer in Cust database in SQL SERVER 2008R2, which is my destination table.
and Other table called customer(same name as above and also same fields) on the oracle server, which is my source table.
I have access of read only in the table which is on the oracle server under the LINKED SERVER folder in SQL SERVER 2008R2.
now I am confuse how can I do the incremental ETL,(insert , update and delete) between source and destination table either via Stored procudre or SSIS package.
Please help me.
May 30, 2013 at 1:55 pm
duplicate post. direct replies here.
http://www.sqlservercentral.com/Forums/Topic1458422-391-1.aspx
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply