Как разделить данные файла falt на основе количества столбцов в источнике?
currently I have a flatfile source it contains more than 20 columns.I do want to divide the hole data into multiple outputs like four different outputs having 5 columns in each output. Output1, output2, output3, output4, output5 column1, column6, column11, column16, column21 column2, column7, column12, column17, column22 column3, column8, column13, column18, column23 column4, column9, column14, column19, column24 column5, column10,column15, column20, column25 What I have tried: <pre>I have tried using conditional split but it did not work out.is it possible to make this output with help of SSIS components?.Thanks in advadnce.
Maciej Los
Почему? Есть ли в этом смысл?
Допустим, у вас есть такие данные, как:
Column_1 Column_2 Column_3 Column_4 Column_5 Column_6 Column_7 Column_8 Column_9 Column_10 Column_11 Column_12 Column_13 Column_14 Column_15 Column_16 Column_17 Column_18 Column_19 Column_20 Data_1_1 Data_2_1 Data_3_1 Data_4_1 Data_5_1 Data_6_1 Data_7_1 Data_8_1 Data_9_1 Data_10_1 Data_11_1 Data_12_1 Data_13_1 Data_14_1 Data_15_1 Data_16_1 Data_17_1 Data_18_1 Data_19_1 Data_20_1 Data_1_2 Data_2_2 Data_3_2 Data_4_2 Data_5_2 Data_6_2 Data_7_2 Data_8_2 Data_9_2 Data_10_2 Data_11_2 Data_12_2 Data_13_2 Data_14_2 Data_15_2 Data_16_2 Data_17_2 Data_18_2 Data_19_2 Data_20_2 Data_1_3 Data_2_3 Data_3_3 Data_4_3 Data_5_3 Data_6_3 Data_7_3 Data_8_3 Data_9_3 Data_10_3 Data_11_3 Data_12_3 Data_13_3 Data_14_3 Data_15_3 Data_16_3 Data_17_3 Data_18_3 Data_19_3 Data_20_3 Data_1_4 Data_2_4 Data_3_4 Data_4_4 Data_5_4 Data_6_4 Data_7_4 Data_8_4 Data_9_4 Data_10_4 Data_11_4 Data_12_4 Data_13_4 Data_14_4 Data_15_4 Data_16_4 Data_17_4 Data_18_4 Data_19_4 Data_20_4 Data_1_5 Data_2_5 Data_3_5 Data_4_5 Data_5_5 Data_6_5 Data_7_5 Data_8_5 Data_9_5 Data_10_5 Data_11_5 Data_12_5 Data_13_5 Data_14_5 Data_15_5 Data_16_5 Data_17_5 Data_18_5 Data_19_5 Data_20_5
Каков будет результат?