Hi, I have 2 db's,Databaseone:Raw data loaded from flat files databasetwo: Loaded data from Databaseone in to relational. Between Databaseone and databasetwo i apply some bussiness rules.I am having problem applying this particular rule: RULE1: When POL_STAT_CD = '07' or When FIU_REQ_ID <> '0000' AND Does not already exist in the DWT_NB_POLICY_MSURE table with MSURE_CD = '0035' then msure_cd = '0035' RULE2: When POL_STAT_CD = '30' AND Does not already exist in the DWT_NB_POLICY_MSURE table with MSURE_CD = '0036' then msure_cd = '0036' Where POL_STAT_CD and FIU_REQ_ID are from table 1 in Databaseone and DWT_NB_POLICY_MSURE is an table from Database2 Both the databases are in the same instance of sqlserver. How can i achieve this? and also there might be an other rule too which may be true then,i shd insert two rows for the same column.. example:if rule 1 and 2 both are satisfied then there should be two records this way: policy number msurecode 12345 0035 12345 0036

TL;DR for your logic... You should be able to accomplish all of this using Lookup components, Conditional Splits, and either OLE DB Commands or OLE DB Destinations. Break down your scenario (like you have) into steps, and use Lookup components to find data related to a row, and Conditional Splits to make decisions based on what you find (or what's already there on the row). Talk to me now on