Logging feature in SSIS 2008

The built in logging in SSIS is fantastic. However , some of you might have tried to implement this in SSIS 2008 only to find that it doesn’t work. Well there are a couple of things I can tell you. The first is that when you use SQL Server logging and point it to a database, it will create the table as a System Table not a normal one. So go to your database and expand – Tables – System Tables and you should see it there. The second is that the table name has now changed to a more relevant ssislog instead of dtslog90.

Countdown to Tech-Ed Africa !

Well , we’re about a month away from Tech-Ed Africa. Last years event in Durban, South Africa was a huge success, and this years event, also in Durban, is going to be even bigger ! We’ve got more international speakers , more tracks and more sessions. I’ll be presenting 2 BI sessions :

1. The Hidden Riches behind Microsoft Dashboards, Scorecards, and Analytics
2. Using MDX for Enhanced Scorecards and Dashboards

I’ll probably also be pulled in to the BI Power Hour. Also , 2 of my colleagues from iSolve , Morne Blake and Mike Molfessis, are also presenting some sessions. You can get the full list here : Tech Ed Africa

Where is the Reporting Services 2008 Web Service ?

Trying to connect to the Reporting Services 2008 web service ? Not able to find the endpoint ? Tearing your hair out in frustration ? Vowing destruction and annihilation to those responsible ? Relax…… The old endpoint has been retired. You need to use the "2005" endpoint ( Although why isn’t this called "2008" ? – just overlooked I suppose ). The address is :

http://SERVER/reportserver/reportservice2005.asmx

Replace "SERVER" with the hostname or IP Address of your Repporting Services server. And you can add "?WSDL" to the end of the URL to get the WSDL. Right , sorted ? If you haven’t investigated the web service yet you really should. It is, in my opinion, one of the best features of reporting services and allows you to really customize your report integration.