February 27, 2009 at 12:01 am
Dear Gurus,
My requirement in to import the new rows from source database to destination database which are in two different servers.
Can anyone please help me in this. how to import.
For example
--------------
Source.
--------------
Select * from Server1.db1.dbo.table1
Pk_Column Column1 Column2
----------- ---------- -----------
1 Value1 Value2
2 Value3 Value4
3 Value4 Value5
Destination
-------------
Select * from Server2.db1.dbo.table1
Pk_Column Column1 Column2
----------- ---------- -----------
1 Value1 Value2
Now i want to insert the two new rows(pk_Column: 2,3) from Source to destination. using SSIS package.
I have to schedule the SSIS package.. for every day end..
please help me in this.
Thank you.
February 27, 2009 at 7:15 am
You have a couple of options.
One is to use a Lookup transform where you send the "error rows" (rows where a match is not found) on to the Destination Component. You would need to Configure the error mode to redirect row.
The other, which will usually perform better is to insert all the rows into a staging table in the same database and then do a Left Outer Join on the destination.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 10, 2009 at 9:39 am
HI Jack Corbett,
Thank you for ur reply,
ok I will try with the loopup transform.
Could you please send me the test package using Lookup transform.
thank you.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply