SSIS with different table structures
- by Grace
I have a flat file source from Excel that has a structure like this:
**People** Day1 Day2 Day3 Day4
Person1 someValue ...
Person2
Person3
And i would like the package to put this information in a database with standard columns 'Person', 'Day', 'Value'. Does anybody know how to do this - at the moment because the days are going along the top, the package is assuming these are seperate data columns when they are not really and the mapping is not working.