SSIS Excel Import - First row getting skipped
Database Administrators Asked by Mithun John Jacob on November 30, 2021
I am using VS 2017(SSDT) with SSIS(2012). I’m trying to import an Excel file, but the issue is that the first row is getting skipped.
I’ve unchecked First row has column names in Excel Connection Manager, but in vain.
Please advice on how to import the first row.
One Answer
This is very easy using the Wizard:
- In your Project, drag a data flow task onto the board
- Double-click the data flow task. being inside the data stream, drag an excel source.
- then we create a new connection to excel by clicking on excel source.
- we look for the excel file that we want to import and select: "the first row has column names"
- we select the table or the view that we have in the excel sheet.
- With this we would already have the process to import the excel data to any destination ...
good Luck...
Answered by CalabreseFRJ on November 30, 2021
Add your own answers!
Ask a Question
Get help from others!
Recent Answers
- Joshua Engel on Why fry rice before boiling?
- Peter Machado on Why fry rice before boiling?
- haakon.io on Why fry rice before boiling?
- Lex on Does Google Analytics track 404 page responses as valid page views?
- Jon Church on Why fry rice before boiling?
Recent Questions
- How can I transform graph image into a tikzpicture LaTeX code?
- How Do I Get The Ifruit App Off Of Gta 5 / Grand Theft Auto 5
- Iv’e designed a space elevator using a series of lasers. do you know anybody i could submit the designs too that could manufacture the concept and put it to use
- Need help finding a book. Female OP protagonist, magic
- Why is the WWF pending games (“Your turn”) area replaced w/ a column of “Bonus & Reward”gift boxes?