Category Archives: SQL Server

Reporting Services 2005 was installed on a virtual machine prior to a sysprep. I received errors from http://localhost/Reports and http://localhost/ReportServer that ultimately indicated that it couldn’t connect to the reporting database. The resolution to this is to run a tool … Continue reading →

There is no Microsoft.Jet.OLEDB.4.0 provider for 64 bit Windows editions. If you need to use an Excel Source task or Excel Connection Manager in Integration Services on a 64 bit machine (I’m using Vista Ultimate x64), you will need to … Continue reading →

How do you perform a Lookup transformation using an input column of type DT_DATE (e.g. from a spreadsheet input) and a SQL Server table column that has the datetime type? Dragging the former onto the latter results in the error … Continue reading →

  I’m using Visual Studio Team Edition for Database Professionals and have spotted a couple of niggles with it. 1) If you rename a foreign key field, the schema compare fails to recognize that it needs to update the foreign … Continue reading →

In Business Intelligence Studio (AKA Visual Studio 2005), when editing a cube, there is a tab for creating calculations. This tab contains a handy ‘script organizer’ pane showing a list of the names of all your calculations, names sets, etc. … Continue reading →

A technical post for a change. We recently noticed a difference in SQL Server 2005 over 2000 around the use of the SCOPE_IDENTITY function. I’ve been used to "SELECT SCOPE_IDENTITY()" returning INT as its data type, as that was the largest … Continue reading →