September 19, 2011 at 10:12 pm
hi friends,
sources data comes like id,name
1,abc
2,nani
3,ravi
4,balu
5,srinu
6,arun
7,anil
8,babu
9,chenu
10,devi
i want send this data to ssend the three destination tables .tables data like
first table second table third table like
id,name id,name id,name
1,abc 4,balu 7,anil
2,nani 5,srinu 8,babu
3,ravi 6,arun 9,chenu
10,devi
how to solve this problem in ssis plesen tell me the proces
September 20, 2011 at 12:48 pm
asranantha (9/19/2011)
sources data comes like id,name
1,abc
2,nani
3,ravi
4,balu
5,srinu
6,arun
7,anil
8,babu
9,chenu
10,devi
I want send this data to ssend the three destination tables .tables data like
first table second table third table like
id,name id,name id,name
1,abc 4,balu 7,anil
2,nani 5,srinu 8,babu
3,ravi 6,arun 9,chenu
10,devi
how to solve this problem in ssis plesen tell me the proces
Use a conditional split and send to three seperate destinations. If the id / 3 is evenly divisible by 3 then send to table 1, if a remainder of 1, then to table 2 and if a remainder of 2 send to table 3.
In you conditional split you could do something like:
Branch 1 -- ([Id] % 3) == 0
Branch 2 -- ([Id] % 3) == 1
Branch 3 -- ([Id] % 3) == 2
HTH,
Rob
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply