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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics