Join two tables of different servers in SSIS
-
Hi, I am new to SSIS. I have two different servers, one is AS400 and other in SQL server. There is one table ABC on AS400 and two table ABC and XYZ in SQL server. I need to take the join of the tables ABC (of AS400) and XYZ of SQL server and need to push the matching records into ABC table of SQL server. Please advise me how can I achieve this in SSIS. Thanks in Advance.
CodeManiac xxxxxxxxxx xxxxxxxxxx
-
Hi, I am new to SSIS. I have two different servers, one is AS400 and other in SQL server. There is one table ABC on AS400 and two table ABC and XYZ in SQL server. I need to take the join of the tables ABC (of AS400) and XYZ of SQL server and need to push the matching records into ABC table of SQL server. Please advise me how can I achieve this in SSIS. Thanks in Advance.
CodeManiac xxxxxxxxxx xxxxxxxxxx
Abhijit Jana | Codeproject MVP Web Site : abhijitjana.net Don't forget to click "Good Answer" on the post(s) that helped you. View My Latest Article
-
Abhijit Jana | Codeproject MVP Web Site : abhijitjana.net Don't forget to click "Good Answer" on the post(s) that helped you. View My Latest Article
Hi Abhijit, Thanks for quick reply. But on clicking the link "This may help you", it redirects me to some where else and I do not have any registration there. It would be great if you can post the solution here. Thanks :-D
CodeManiac xxxxxxxxxx xxxxxxxxxx
-
Hi, I am new to SSIS. I have two different servers, one is AS400 and other in SQL server. There is one table ABC on AS400 and two table ABC and XYZ in SQL server. I need to take the join of the tables ABC (of AS400) and XYZ of SQL server and need to push the matching records into ABC table of SQL server. Please advise me how can I achieve this in SSIS. Thanks in Advance.
CodeManiac xxxxxxxxxx xxxxxxxxxx
-
Hi Abhijit, Thanks for quick reply. But on clicking the link "This may help you", it redirects me to some where else and I do not have any registration there. It would be great if you can post the solution here. Thanks :-D
CodeManiac xxxxxxxxxx xxxxxxxxxx
I really surprised to see the same thing happening with me. :doh: It was fine, when I was post the answer. :doh:
Abhijit Jana | Codeproject MVP Web Site : abhijitjana.net Don't forget to click "Good Answer" on the post(s) that helped you. View My Latest Article
-
I really surprised to see the same thing happening with me. :doh: It was fine, when I was post the answer. :doh:
Abhijit Jana | Codeproject MVP Web Site : abhijitjana.net Don't forget to click "Good Answer" on the post(s) that helped you. View My Latest Article
Hi Abhijit/CodeManiac, Expert exchange displays the answers at the bottom when your referrer is Google. Try searching for the question title "Linking, Connecting MS SQL 2000 to AS400 Database" using Google, go to the first result, and scroll down to the bottom of page to view the replies. Hope that helps. Regards,
Syed Mehroz Alam My Blog | My Articles
Computers are incredibly fast, accurate, and stupid; humans are incredibly slow, inaccurate and brilliant; together they are powerful beyond imagination. - Albert Einstein