Thursday, November 9, 2017

cyclocross laps plotted

plotted out the first four laps of a local cyclocross race. Limiting the field to the top ten finishers in a the mens categories of 3/4, 4/5,1/2/3, and masters 35+,45+.
I think this illustrates there is a ton of over lap between the 3/4 and 4/5 field, and that the 1/2/3 field is roughly head and shoulders better than any other field. That being said theres clearly one or two masters outliers

Monday, February 6, 2017

ssis dataflow excel connection in a foreach loop

Recently when using a foreach enumater to set an excel file path in a foreach loop in SSIS I ran in to a problem. In this case it was where the loop would act as if it were successfully processing several excel files, but the data would not change. I even put a script output on the data flow to write the filenames to a log to make sure I wasn't just running the same file over and over. Turns out on the excel connection manager properties.. The same place where you go to set the expression to change the excelFilePath for each iteration of the loop, there is a setting called RetainSameConnection.
Having this set to true was not allowing the expression to overried the file path.

I feel like in older versions of Visual Studio I was able to processed multiple files in a foreach loop without checking this box.