how read data range in Excel to import ?

Question

Post reply

how read data range in Excel to import ?

tomoko667

SSC Veteran

Points: 225
More actions
October 6, 2008 at 9:36 pm

#125051

Hi,
Im having a problem when I import excel file.
The Date range I wanna SSIS to read is started at the cell "C5"(5th Row: Field, 6th Row:Data)
could someone help me how to set the Date Range??
thank you.
tomoko

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

lucazav SSC Eights! Points: 981 More actions · Answer 1

Look at this:

http://weblogs.asp.net/mikebosch/archive/2007/10/26/ssis-skipping-rows-and-stripping-subtotals.aspx

😉

tomoko667 SSC Veteran Points: 225 More actions · Answer 2

hi, LucaZAV

thanks for the site.

It looks hard to me, but I will try.

thank you.

tomoko

bang.prashant Ten Centuries Points: 1100 More actions · Answer 3

import everything in stagetable and then delete first five rows

Jim Russell-390299 SSCrazy Eights Points: 9333 More actions · Answer 4

Can you set the named range in the sheet? If you do, the "data sets" available to import will include both the worksheet tabs (suffixed with a "$") and your named range(s).