Click here to Skip to main content
15,940,246 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I need to import data from a Microsoft Excel comma-separated Values file to a table within a SSIS Data Flow.

While using a Flat File Source or an Excel source my .csv file is not recognized.

What I have tried:

I created a new Excel Source in the Data Flow, double-clicked on it, clicked on New (in the "Connection Manager" panel), and inserted the path of my file but it's not visible.
Updated 11-Jan-21 16:38pm

1 solution

Check this article which has more than enough steps with required screenshots. Search Web for more similar articles
Importing CSV File Into SQL Server Using SSIS[^]
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900