Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 How to use Conditional Split or SCD

Author  Topic 

WoodHouse
Posting Yak Master

211 Posts

Posted - 2010-06-20 : 02:19:23
Hi

Guys please guide me how to achieve this in ssis.

It's row by row operations.

first step

i need to check if record not exists i will append the record to consolidated table.

If record exists we will update the records information.

we have the unique ID column.

i upload the flow chart please find

please help on this

thanks

   

- Advertisement -