July 30, 2012 at 5:43 am
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
July 31, 2012 at 6:52 am
Hi ,
Use result set and condition split .
July 31, 2012 at 9:34 am
Hi,
Enjoy SSIS Data flow transformation component "Conditional Split". 🙂
August 1, 2012 at 1:40 am
in condition spilt what logic we want to implement.how to data comes sheets wise .plz tell me some steps.
August 1, 2012 at 11:29 am
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
August 2, 2012 at 11:11 pm
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.
August 2, 2012 at 11:23 pm
In your case, use deptno.In Condition tab, you can define deptno = 101 as one case and deptno = 110 as another case.
August 3, 2012 at 1:02 am
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