What is the source type for .CSV files in SSIS

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 create开发者_JAVA百科d the Package for excel and load the data to SQL server.

please advice me........

Thanks in advance....

You need Flat File source, not Excel.

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

Bulk Insert to SQL