Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

split table data into multiple execel sheets in ssis Expand / Collapse
Author
Message
Posted Monday, July 30, 2012 5:43 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 10:21 AM
Points: 197, Visits: 4,400
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
Post #1337190
Posted Tuesday, July 31, 2012 6:52 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, April 07, 2014 4:56 AM
Points: 20, Visits: 126
Hi ,
Use result set and condition split .
Post #1337864
Posted Tuesday, July 31, 2012 9:34 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, November 18, 2013 4:25 AM
Points: 27, Visits: 40
Hi,
Enjoy SSIS Data flow transformation component "Conditional Split".
Post #1337989
Posted Wednesday, August 01, 2012 1:40 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 10:21 AM
Points: 197, Visits: 4,400
in condition spilt what logic we want to implement.how to data comes sheets wise .plz tell me some steps.
Post #1338343
Posted Wednesday, August 01, 2012 11:29 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 9:25 AM
Points: 7,070, Visits: 12,523
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

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy
Post #1338705
Posted Thursday, August 02, 2012 11:11 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 10:21 AM
Points: 197, Visits: 4,400
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.
Post #1339626
Posted Thursday, August 02, 2012 11:23 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 3:10 AM
Points: 199, Visits: 500
In your case, use deptno.In Condition tab, you can define deptno = 101 as one case and deptno = 110 as another case.
Post #1339631
Posted Friday, August 03, 2012 1:02 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 10:21 AM
Points: 197, Visits: 4,400
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
Post #1339658
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse