Post reply

Diffrentiate the data With Out Using Conditional Split

  • November 18, 2011 at 7:41 am

    #246630

    Hi,

    Greetings!!!

    Example: In a Table 1000 Records are exists with a column of Salary. I want to differentiate the data with salary column Greater than of 5000/- and Less than Of 5000.

    But In package should not use Conditional Split.

    Is there any other process?

    By using the precedence constraint we can achive that. But How to Impliment?

    Thanks & Regards

    Indher Sarvade

  • November 20, 2011 at 5:04 pm

    #1410442

    Hi,

    There are many ways you can 'differentiate' between >5000 and <5000.

    But why not use a conditional split?

    What is it you are trying to achieve? Do you want them to go to different destinations? Append something (like an extra column/value)?

    You could use separate queries.

    You could use derivations.

    You could use a script.

    You could use an Execute SQL task and a Foreach loop...

    I'm not sure how you can achieve it with a precedence constraint, though.

  • November 20, 2011 at 11:56 pm

    #1410490

    Why on earth wouldn't you use a conditional split? It is made exactly with that purpose.

    You could write a script component that routes the rows to different outputs according to the salary column, but you would just be mimicking the conditional split.

    Precedence constraints won't help. They are active at the control flow, not in the data flow.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • November 21, 2011 at 12:41 am

    #1410507

    Hi Sam,

    Could you help me out, by using Script Component how we can achive that.

    Can you send me a Link or Code of the process to achive <5000 and >5000 records.

    Thanks for your support.

    Thanks & Regards

    Indher Sarvade

  • November 21, 2011 at 12:51 am

    #1410510

    sarvade.inder (11/21/2011)

    Hi Sam,

    Could you help me out, by using Script Component how we can achive that.

    Can you send me a Link or Code of the process to achive <5000 and >5000 records.

    Thanks for your support.

    Thanks & Regards

    Indher Sarvade

    Here you go:

    http://consultingblogs.emc.com/jamiethomson/archive/2005/09/05/SSIS-Nugget_3A00_-Multiple-outputs-from-a-synchronous-script-transform.aspx

    It should be self explicative from there.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • November 21, 2011 at 2:19 am

    #1410545

    Conditional Split is the best method for such cases.

  • November 21, 2011 at 3:13 am

    #1410570

    Hi Koen,

    Thank you Very Much..... 🙂

    Thanks for your support.

    Thanks & Regards

    Indher Sarvade

  • November 21, 2011 at 3:44 am

    #1410576

    sarvade.inder (11/21/2011)

    Hi Koen,

    Thank you Very Much..... 🙂

    Thanks for your support.

    Thanks & Regards

    Indher Sarvade

    No problem, glad to help.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply