Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  SSIS and Import/Export (2008)  Import data from 2D table to SQL

Author  Topic  pecunn Starting Member 20 Posts Posted - 2011-05-18 : 03:50:03 Dear anyway who experts in SSIS, i have excel spreadsheet with 2D data. personColoum | isDeveloper | isDBA | isManager | personA | TRUE | FALSE | TRUE | personB | TRUE | TRUE | TRUE | personC | FALSE | FALSE | TRUE | PersonD | TRUE | FALSE | FALSE | what i have to do is, if the status true i need to get primaryID from header coloum and row coloum then enter into composite table. for example in 'TRUE' cell in red color, i have to get primaryID for isDBA then personB and put it into new table. The question is this something possible be done in SSIS?