Post reply

Split the query by Filters

  • November 7, 2016 at 12:52 pm

    #315398

    I have a Query which is in SSRS , and has parameters . I want that query in SSIS , meaning one source and 3 different destinations( filters in ssrs), In report we choose filters in SSIS how can we do it?

    how can i do by conditional split?

    example :

    Select * from A where region in ( US,ASIA) and device in ( iphone , android)

    Select * from A where region in ( US,ASIA) and device in ( tablet , notebook)

    this is in SSRS

    how can we do in SSIS? one pacakge , one source/query and different filters . Please findthe attached picture for reference.

  • November 7, 2016 at 12:57 pm

    #1911010

    You need a single conditional split, with three different outputs.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • November 7, 2016 at 1:00 pm

    #1911013

    Ok. first let me ask. How can we write condition in conditional split where State in (us ,asia)?

  • November 7, 2016 at 1:14 pm

    #1911018

    komal145 (11/7/2016)

    Ok. first let me ask. How can we write condition in conditional split where State in (us ,asia)?

    Something like this

    UPPER(State)=="US"||UPPER(State)=="ASIA"

    Slightly off topic, but the United States is a country and Asia is a continent 😉

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • November 7, 2016 at 1:22 pm

    #1911023

    🙂

Viewing 5 posts - 1 through 4 (of 4 total)

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