Hi, I have a conditional split transformation in my data flow task which has a condition 1. NEW ROWS and the Expression is 'ISNULL(CUSTOMER_KEY_PK) 2. Updated rows and the expression is 'CUSTOMERID != CUSTOMERID Default out put is updated rows. Now my problem is I have loaded my customer table once after that there is some with my data and I had deleted all the rows in my customer table. Now after deleting the rows while I am trying to load the data, I can only see the rows coming from the source and loaded till conditional split. but they are not passing through the conditional split. According to me, the conditional split task should perform incremental task which satisfies the above condition and load the data. As i have deleted all the records in my destination CUSTOMER table, there will only be nulls in the customer_key_pk, which make it possible to load full load. I can only see all the rows are diverted to the updated rows side. As I have deleted the rows while I am running the task all the new rows should be inserted in to the destination and any updated rows that are available should satisfy the 2nd condition and diverted to another destination(Updated rows destination) My destination table is CUSTOMER table. Customer_key_pk is primary key in my destination table and is reference in conditional split using lookup transform above conditional split. CUSTOMERID is coming from my source and i have pulled the destination CUSTOMERID using a lookup transform to compare in conditional split. Please help if I am missing out something. Thanks in advance, Sam.

Can you post your Derived Column expression here the way it exactly looks and please set the data viewers to capture how the data look like and post that here too for us to see.Arthur My Blog

Following is the conditional split that is available in my data flow task

How CUSTOMERID != CUSTOMERID can be ever not equal?Arthur My Blog

Hi Arthur, Thanks for responding. Actually my thinking to wards this expression is, If the CUSTOMER_KEY_PK is null and CUSTOMERID is new then the CUSTOMERID != CUSTOMERID condition succeeds and the new rows get inserted into the destination. Correct me if I am wrong. Also let me know if I can use only single condition (New Rows or Case1) to insert new rows into the destination. Actually I am new to this. Thanks for your patience in replying to my post. please guide me in implementing Conditional Split. Thanks, Sam.

My data flow task is as follows. I am attaching this to clarify if there is any thing I can change from it. Thanks, Sam.

Hi Sam, How do you know it is new? Are you trying to look up the previous row? And are you trying to achieve some sort of data synchronization? If yes, then why don't you look at this post: Get all from Table A that isn't in Table B http://www.sqlis.com/sqlis/post/Get-all-from-Table-A-that-isnt-in-Table-B.aspxArthur My Blog

Hi Arthur, Can you please help me out in this conditional split. I want only new rows to be inserted into my destination table and can you please let me know how can achieve this. Thanks in advance. Sam.

SSIS Conditional split transformation is very useful for usually applying business rules where certain rows need to have slightly different transformation applied (data cleansing) or need to be re-directed to different destination for user input. Another example is to split source into equal groups which is less common example but this is something I need to do in order to achieve parallel processing. Althought I used for parallel processing in control flow you could use this method to achieve better performance inside data flow as well. Check more info for ssis conditional split