SQLTeam.com | Weblogs | Forums

Import Flat file to table in SSIS using pivot (or suggestions please)


#1

Good day. I am new to SSIS and struggling at the first hurdle.
I have a flat file that I want to import into a table using SSIS. Skipping the first row, I want to load every 4 rows into a row in a table.
For example.

My File 04/06/2015
"Matthew"
"Mark"
"Luke"
"John"
"Peter"
"Pawel"
"Marcus"
"Julie"
"Alfred"
"Henry"
"Clare"
"Jill"
"Amber"
"Matrin"
"Kim"
"Leila"

Should look like:
col1 col2 col3 col4
"Matthew" "Mark" "Luke" "John"
"Peter" "Pawel" "Marcus" "Julie"
"Alfred" "Henry" "Clare" "Jill"
"Amber" "Matrin" "Kim" "Leila"

What in your expert opinions would be the easiest way to achieve this? I'm still at Flat file source :frowning:
Thank you


#2

import all the data into SQL from flat file.
modify the data in SQL as you want