loading multiple Import sets issue

[abhijats]

Hi All,

There is a query related to loading multiple Import sets.
after loadind data and creating transforming map, when I click on Run transform I have a slush-bucket and a combox have all names of all transform maps but when i choose the names at a time only one transform map is getting selected for Transform. I am not able to get more than one transform map in available list!
How can I make more than one transform maps to get transformed in detination table, My aim is to loading multiple import sets at a time.
for more information please see attached document.

[tony_fugere]

The Transform Maps MUST belong to the same SOURCE table. They can have different destination tables though. Here is a test I just tried out and it works fine!

[abhijats]

Thanks Tony.

[sndevelopertm]

can this be used to load multiple worksheets from the same excel sheet as the datasource? how to reuse the excel file loaded ?