Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Source - Cannot Specify Number of Rows to Skip?

Status
Not open for further replies.
JohnBates

JohnBates

MIS
Feb 27, 2000
1,995
US
hi all,

I'm very new to SSIS so here goes.

I need to import an excel worksheet --> a database table.

Easy. But in the Excel Source data flow, there doesn't seem to be a way to specify how many rows to skip for header lines etc.

I'm overlooking something I'm sure...

Thanks, John
 
Status
Not open for further replies.

Similar threads

Cpreston
  • Locked
  • Question
CSV to SQL table with not allow null issue
Replies
3
Views
443
Cpreston
Cpreston
dbsql
  • Locked
  • Question
get existing record from source to destination
Replies
0
Views
258
dbsql
dbsql
minhtran360
  • Locked
  • Question
Where do I look for my SSIS pasckage that just being deployed to my sql server?
Replies
1
Views
1K
mark williams
mark williams
grnzbra
  • Locked
  • Question
Excel Import Maps 255 Char Max
Replies
0
Views
294
grnzbra
grnzbra
lavadan
  • Locked
  • Question
CSV file escape phone number format
Replies
0
Views
291
lavadan
lavadan

Part and Inventory Search

Sponsor

Back
Top