SSIS data import in asp.net

Question

Hi, In my project I have import data from CSV file using SSIS package in asp.net environment. The CSV file contains Header section and details section. The Header section will contains the summary of the details section. The details section contains the records of the item sold by the company. The header will contains the total number of records in the details and sum of the amount of all items. I need to validate the file before importing the data to the database. Please suggest some link or tutorial.

Answer 1

Should teach the basics to get you started:

How to import an Excel file into SQL Server 2005 using Integration Services

Import Data From Comma Seperated Values .csv Flat File Into SQL Server Database Table using SQL Server Integration Services SSIS

Answer 2

I tried different ways but only solution of Andy Leonard worked for me. SSIS Design Pattern: Loading Variable-Length Rows.
I only replaced String.Split by Regex.Split in the Script component.
You can validate the data in Script component.
I installed the Integration Services on the web server but you can choose another option. Check this link