Monthly Archives: June 2007

Excel Connection Manager and Excel Source in Windows x64

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

Posted in SQL Server | Leave a comment

SSIS Lookup Transformation for SQL Server datetime type and DT_DATE

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

Posted in SQL Server | 1 Comment

Bugs/Omissions in Visual Studio Team Edition for Database Professionals

  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

Posted in SQL Server | Leave a comment

Calculated Measures DisplayFolder

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

Posted in SQL Server | 1 Comment

SCOPE_IDENTITY()

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

Posted in SQL Server | 1 Comment