How to load data (key range) to 3 worksheets

How to load data (key range) to 3 worksheets in a single excel target? (Let me clear you, I had 3000 records data need to be processed in a mapping and to load the data 1-1000 recs into worksheet 1,1001-2000 on second....)


Reach me sriram_kumar @ oneindia . in

for this create the source partitoning and make three targets on the base of key range.In the session properties we can define the sql query with key range so tht each qualifier read only tht range of records and loads in to corresponding target table.

Thanks Reetasharma.

The concern is not about Pipeline Partition..but loading data into 3 worksheets of a single Excel Sheet.