SQL and Shipping Optimization

I need to optimize my shipping process. I need to take datas from sql2005 server and then I think to use Google Directions Api to optimize the locations order. But I don't know if it is the best solution to use those api or if there's another service to directly show the result of a query on google maps and then calculate the best road. My query must look to destinations in the next 3 weeks. So I need also to crop this order, selecting for example 3 or 4 location for each day in the next 3 weeks. Can you help me to find the best solution? Thank you!