Hi,

Set up a SSRS report with lon and lat parameters. Then add a data source as XML type with the following connection string formula;

="http://api.openweathermap.org/data/2.5/weather?mode=xml&units=metric&APPID=yourAPPID&lat=" & Parameters!Latitude.Value & "&lon=" & Parameters!Longitude.Value

Then...

1) Add a For Loop container and in the eval expression and 1==1 (so always returns true and will continuously loop).

2) Inside the container add a script task to check...

I had a similar issue, re not having office installed on the server.

I ended up using Windows Scheduler on a machine with office installed. This just opened an excel file...

That's awesome. Exactly what I was after.

Thanks so much,

Craig