Skip rows in Excel using SSIS

I have an Excel file that I am using as my source to create a CGL file in SSIS. I need to skip the first 5 rows every time and only want data from the following columns. F6,F7,F5,F64,F10,F86,F11,F61,F63,F167,F125,F87,F2 is there an easy way to accomplish this task in SSIS?
Who is Participating?
Reza RadConnect With a Mentor Consultant, TrainerCommented:
Easiest would be to give each row a number (a bit like an identity in SQL Server) and then use a conditional split to filter out everything where the number <=5


you can use the OpenRowset() property on the Excel Datasource. Something like Sheet1$A6:Z5000, check this link for more details: 
mburk1968Author Commented:
I get the following error attached. this is what I placed in OpenRowSet: HeaderTemplate$A6:FK100
A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

try adding brackets there
mburk1968Author Commented:
Screen shot of error attached after using []
ralmadaConnect With a Mentor Commented:
Well, I'm not sure why the suggestion I given in the link on my first comment didn't work, but alternatively you can try this link: 
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.