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 Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, September 12, 2014 2:11 AM
Points: 211, Visits: 4,540
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 7, 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 1, 2012 1:40 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, September 12, 2014 2:11 AM
Points: 211, Visits: 4,540
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 1, 2012 11:29 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, September 26, 2014 7:33 AM
Points: 7,107, Visits: 12,660
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
Post #1338705
Posted Thursday, August 2, 2012 11:11 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, September 12, 2014 2:11 AM
Points: 211, Visits: 4,540
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 2, 2012 11:23 PM


SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, June 18, 2014 3:47 AM
Points: 199, Visits: 512
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 3, 2012 1:02 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, September 12, 2014 2:11 AM
Points: 211, Visits: 4,540
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