I need to import text file (csv) into the SQL Server DB using VB. This has
to be done programmatically by creating DTS package. My problem is splitting
of the column i.e if I receive the data as (one row is shown as eg)
1, George Bush,Male,Texas

The export table should contain 5 columns (Instead of 4 columns)
i.e. The columns should have values like:
col1: 1
col2: George
col3: Bush
col4: Male
col5: Texas

Any code or supporting URL’s will be greatly appreciated

Thanks