How dynamically fetch cell range data from excel source in ssis? RRS feed

  • Question

  • Hello Team,

    I have data from pivot table in excel sheet. My header is on Sheet1$A5:D5. and all values are in Sheet1$A5:D6-D230000. But cell range is not fixed sometimes it is Sheet1$A5:D4000 or sometimes Sheet1$A5:D350000 so i really dont know cell range . As for time being i did (select * from [sheet1$A5:D1048576]) to avoid cell range but as i mentioned i am using pivot data so there are so many filters are coming that reflects error if i am using my select query statement.

    Please i really need developers help if i can do through script also or may be some other ways. Please try to give me as SSIS package.

    Thursday, November 15, 2018 7:27 PM

All replies