Hi I thought that this was a really easy task to do with SSIS but I´m stuck. All I want to do is do inserts when a row don´t exist and do an update when it does. As an identifier I have a GUID. I´m currently trying using lookup. I have one OLE DB source and two OLE DB destinations. When there is no match I create a new post, otherwise I update the post. I really need some help. Rednaw

Ok but where are u struck with ??? use look up and select ignore failure at look up transformation component next introduce conditional split task where in split your output [failed look up rows] : direct these staright away to oledb destination . rest result is the one that needs to be updated : instead of other oledb destination use "oleDB command" component and update ur records. Hope that helps ... Kunal

check this.... Let us TRY this | My Blog :: http://quest4gen.blogspot.com/

Configure lookup transform pointing to table and set no match rows as redirect to no match output then connect match output to an OLEDB Command transform to update and connect no match output to destination ( for example oledb destination) for inserthttp://www.rad.pasfu.com

check this.... Let us TRY this | My Blog :: http://quest4gen.blogspot.com/ that exactly what reza and i had meant you can have detailed and fair idea about how to go about step by step ... Hope that helps ... Kunal