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!

Linking to excel file

Status
Not open for further replies.
micang

micang

Technical User
Aug 9, 2006
626
US
SQL 2005,

Hi All,

I am linking to an excel file from SSIS. The problem is the first row in the excel file is blank, so sometimes it either use F1, F2, F3 as column headings, or sometimes takes the first row that has data, as column headings.

I would like to know if there is a way from within SSIS to manupulate the excel file by inserting headings?

Example, I could open up the excel file, type in the column names, then link and it would be fine. so basically could I do this from within SSIS and not need to physically go and amend the source excel file?

Any info will be very appreciated.

Michael
 
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
Cpreston
  • Locked
  • Question
Update File with only new records
Replies
1
Views
338
fredericofonseca
fredericofonseca
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
arunaramana
  • Locked
  • Question
use case to 'Name and Extension', 'Full Qualified' and 'Name Only' options in foreach file enumerato
Replies
0
Views
266
arunaramana
arunaramana
grnzbra
  • Locked
  • Question
Excel Import Maps 255 Char Max
Replies
0
Views
294
grnzbra
grnzbra

Part and Inventory Search

Sponsor

Back
Top