SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks.
SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data.
I have been working with creating custom tasks for SSIS for years now. A number of people asked about custom task for weather. Having accurate weather data as part of your data warehouse can help you understand sales in relation to weather. OpenWeatherMap is a free API which contains current weather data through the world.
DAIMTO OpenWeather for SSIS contains a custom connection and Datasource reader.
Currently the tasks are being built in SQL Server 2005, 2008, 2012 and 2014.
DAIMTO OpenWeatherMaps DataReader
The data reader supports longitude and latitude as well as country, city and zip code requests for current weather.
DAIMTO OpenWeatherMap connection manager
The DAIMTO OpenWeatherMap connection manager manger allows you to supply your own API key to OpenWeatherMap. You will need to sign up for open weather in order to get an API key to use the API. OpenWeatherMap does not charge for using this portion of the API as this time.