Hi,
I am using the looping example here http://www.sqldts.com/default.aspx?246
My csv files are in the following two formats.
"TEXT","OTHERTEXT",12/12/2005,56.4
&
"TEXT","OTHERTEXT",12/12/2005,56.4,"UK"
In effect, I think I need to count the columns in the csv file...