What is the source type for .CSV files in SSIS

Question

I am new to SSIS.

I have a sample .CSV file and i want to transfer the data from .CSV file to SQL DB.

So what is the DataSource type for .csv files.

I created the Package for excel and load the data to SQL server.

please advice me........

Thanks in advance....

Answer 1

Use a bulk insert which is describe in this forum post here:

Bulk Insert to SQL

Answer 2

You need Flat File source, not Excel.