How to split the falt file data based on number of columns in a source?

Question

0.00/5 (No votes)

See more:

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.

Posted 23-May-18 20:25pm

Member 11337367

Add a Solution

Comments

Maciej Los 24-May-18 5:04am

Why? Does it make sense?

Let say you've got a data like:

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

What would be the output?

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)