More design meetings this week, they don’t seem to be stopping anytime soon. The underlying structure of the application hasn’t change design wise, but now we are at the hard part of figuring out how each part will actually works. For the builder we decided that the application would read csv files containing all the raw shipment information from selected source databases and create a freight move object which contains other smaller objects for load, stop, status, and other information. The analyzer would then take this freight move object and parse out critical information to be used by the calculator and store this information in an eval object. The calculator will then do basic calculations using this eval data and write the results to a new TPS database. The other co-op and I were tasked with creating an ssis package that would read data from our current database in a 1 month range from the current day and write this data to csv files to be used as test files for the freight builder part of the application.