I have to pull the data from the excel sheet ... but i don't want the rows from 11 to 211..... how to do it using transformation ....
Thanks in Advance
while picking teh excel file click the Enable transformation step >> Garbage >>Conditional Delete>>Range
and then select the "From" and "To" buttons to specify ypor range.
... or just add a Where clause on your load statement:
Load ... From ... Where recno()<11 or recno()>211 ;
Retrieving data ...