SSIS - Split input file into 12 Months
Good day, I need help please.
I have an input file with 10 columns, i need to split the file into 12 months for the year.
The file is a year grand totals, i know i have to split the col/measures by 12.
But how do i split into 12 months & total.
Please direct me in how
October 21st, 2010 11:40am
Please share your input file data and required output.Let us TRY this |
My Blog :: http://quest4gen.blogspot.com/
Free Windows Admin Tool Kit Click here and download it now
October 21st, 2010 11:45am
Hi, just thought of it using 12 derived columns with Total divide by 12 then use a Union All to a period column
October 21st, 2010 11:59am
Would love to see some input data sample and expected output as ETL has already requested earlier.Nitesh Rai- Please mark the post as answered if it answers your question
Free Windows Admin Tool Kit Click here and download it now
October 21st, 2010 12:27pm
Hi, I hope this helps
Input: Item | Meas1 | Meas2
01 | 12 | 24
Output: Period | Item | Meas1 | Meas2
2011.01 01 1 2
2011.02 01 1 2
Regards
October 21st, 2010 12:57pm
my previous suggestion did not work (derived col)
Free Windows Admin Tool Kit Click here and download it now
October 21st, 2010 1:00pm
Hi, I hope this helps
Input: Item | Meas1 | Meas2
01 | 12 | 24
Output: Period | Item | Meas1 | Meas2
2011.01 01 1 2
2011.02 01 1 2
Regards
use a script component and create an output column "period", OutMeas1, OutMeas2.
use a loop for each record (12 times) which will assign the values to your output columns.
let us know if you have any doubt.
Let us TRY this |
My Blog :: http://quest4gen.blogspot.com/
October 21st, 2010 1:05pm
Thank you - i got the idea :)
Thanks for helping
Free Windows Admin Tool Kit Click here and download it now
October 21st, 2010 1:32pm