I have a need to use a data set and read a csv file. I can't use the built in CSV data set reader because it assumes the first row of the data set contains column headers. In my case the first row of the csv contains actual data. I was considering using a scripted dataset to open read through the file, but I just can't seem to get the results I am looking for. I seem to be able to open and read the file in a scripted dataset, but it doesn't seem to increment through the file. It just sits looping on row 1.
Does anyone have any suggestions or examples for doing this? I have some ideas I can implement with some modest code, but it just seems like there should be an easier way.