split table data into multiple execel sheets in ssis

  • how to send table data into multiple sheets in ssis.

    supoose table data like id ,name,deptno

    1 ,jai ,100

    2,ravi,360

    7,ran,100

    12,nani,100

    8,balu,360

    11,hari,101

    12,nani,101

    14,cani,104

    this data load into excel sheets like first sheet name deptno100 data like id,name,deptno

    1,jai ,100

    7 ,ran ,100

    12,nani,100

    and same process second sheet name deptno101 data like id,name,deptno

    11,hari,101

    12,nani,101

    and similary third sheetname like deptno104 data like id,name,deptno

    14,cani,104

    and another shhet name like deptno360 data like id,name,deptno

    2,ravi,360

    8,balu ,360

  • Hi ,

    Use result set and condition split .

  • Hi,

    Enjoy SSIS Data flow transformation component "Conditional Split". 🙂

  • in condition spilt what logic we want to implement.how to data comes sheets wise .plz tell me some steps.

  • Time to do some homework.

    Documentation: Conditional Split Transformation - SQL Server 2005

    And here is a visual example of Conditional Split:

    Handling NULL Values in SSIS Using The Conditional Split Transformation

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • in condition split what logic we impliment. i know idea what type of transformation we use that task.

    in that transfromation what we do that process tell me. its help for me.

  • In your case, use deptno.In Condition tab, you can define deptno = 101 as one case and deptno = 110 as another case.

  • what ever u say logic .how is it possible to send that data into sheets wise.that means we load data in one excel sheet and that one excel sheet only we load seprately data to load sheet1 and shhet2 like that way.but ur logic not working .my task.

    tell me how to do

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

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