How to read multiple sheets from source excel file

[himridul]

Hello guys,

Can anybody tell me if it is possible to read all the sheets in an excel file as a source ? Let's say, if I have 3 sheets (sheet1,sheet2 and sheet3) filled with data in the input excel data file, would that be possible to import all the data (from 3 sheets) in the mapping designer ? If yes , then plz lemme know the process.

Thank You in advance. Appreciate ur help on this.

 

[ArtieChoke]

Sure, but it's kinda sucky. PowerCenter needs named ranges to use excel, so you would need a different named range in each sheet.

And you would have to create a source for each one.

"I think we're all Bozos on this bus!" - Firesign Theatre

 

[fearthellama]

Another method is to use the Unstructured Data transformation. If you have it, you will find "Unstructured Data" on the transformation list. It can extract everything or specific portions to an XML doc. Very cool stuff. I have used it to parse everything from word docs to EDI messages.