sql server - SSIS: Data transform delimited rows to field -


i have got table containing rows of related data need transform within ssis package , not sure how go it.

in table rows related each other separated row contains pipe character e.g.

test line 1_1
test line 1_2
test line 1_3
|
test line 2_1
test line 2_2
test line 2_3
|
test line 3_1
test line 3_2
test line 3_3

etc..

i need move table , concatenate lines of each group of rows 1 line separated pipe delimiter. above example need end in table:

test line 1_1 test line 1_2 test line 1_3
test line 2_1 test line 2_2 test line 2_3
test line 3_1 test line 3_2 test line 3_3

i not sure how it. thought exporting text file reimporting using pipe delimiter - work dealing millions of rows , rather aviod overhead, there must way in ssis @ moment not sure how.

any appreciated, thanks.

you can create data flow task uses source component. source retrieve data sql statement.

then, add script component transformation. script component must set asynchronous. select inputs , outputs tab of script component, , select output 0. set synchronousinputid none. allow component output different number of rows number of rows input. add new column below output columns branch.

in script component, can concatenate data wish. default, input buffer row , output buffer output0buffer. can use row.nextrow() next input row , output0buffer.addrow() add new output rows.

given sample data, can add input data output buffer until '|' appears. or, can use counter if fits data.


Comments

Post a Comment

Popular posts from this blog

asp.net - repeatedly call AddImageUrl(url) to assemble pdf document -

i'm using abcpdf , i'm curious if can recursively call addimageurl() function assemble pdf document compile multiple urls? something like: int pagecount = 0; int theid = thedoc.addimageurl("http://stackoverflow.com/search?q=abcpdf+footer+page+x+out+of+", true, 0, true); //assemble document while (thedoc.chainable(theid)) { thedoc.page = thedoc.addpage(); theid = thedoc.addimagetochain(theid); } pagecount = thedoc.pagecount; console.writeline("1 document page count:" + pagecount); //flatten document (int = 1; <= pagecount; i++) { thedoc.pagenumber = i; thedoc.flatten(); } //now try again theid = thedoc.addimageurl("http://stackoverflow.com/questions/1980890/pdf-report-generation", true, 0, true); //assemble document while (thedoc.chainable(theid)) { thedoc.page = thedoc.addpage(); theid = thedoc.addimagetoc
Read more

java - Android recognize cell phone with keyboard or not? -

in android app, want detect user's device if device has keyboard(like motorola milestone) , show corresponding user interface. guys know how that? ! regards justicepenny http://developer.android.com/reference/android/content/res/configuration.html public int keyboard the kind of keyboard attached device. 1 of: keyboard_nokeys, keyboard_qwerty, keyboard_12key. that's it!
Read more

iphone - How would you achieve a LED Scrolling effect? -

how achieve led scrolling effect example below? led sign - led ticker emulator iphone , ipad http://img.skitch.com/20101201-rsfh4p1bajb1wp94k466pdpiuj.preview.jpg sometimes remunerates comment in other posts :) have put code you, should implement font '8pin matrix' realistic feeling. uilabel *label; - (void)viewdidload { [super viewdidload]; label = [[uilabel alloc]initwithframe:cgrectmake(10, 50, 300, 20)]; label.font = [uifont fontwithname:@"courier-bold" size:16.0]; label.backgroundcolor = [uicolor blackcolor]; label.textcolor = [uicolor greencolor]; label.linebreakmode = uilinebreakmodecharacterwrap; // otherwise "…" label.text = @"this led text scrolled "; // blanks space between [self.view addsubview:label]; [nstimer scheduledtimerwithtimeinterval:0.12f target:self selector:@selector(scrolllabel) use
Read more