Hi Koen,

Basically in the excel file, data has been downloaded in a pivot format from a sql server (to which I dont have access). And this pivot has high level details. The only way I can see all details behind the pivot is to double click and expand. There is no tab/sheet in this excel sheet that has all the data. Is it possible to do the same step in SSIS?

Rgds