Compare csv file layout to SQL server table layout in VS2005

I am creating a facility whereby you can select a source file (.csv), and a target (SQL table).

Then I call a DTS to copy the csv file to the SQL table.

How can I validate that the two files have the same number of columns BEFORE calling the DTS (ie, in my VB app)?

I need to ensure that the user has selected the correct source and target.