March 2007 - Posts

• Enable multi-phase data pump in DTS editor (Management Studio)

  If you edit a legacy DTS package with SQL Server Management Studio, you may want to know how we can show the multi-phase data pump operations. I haven't found an option to do this with SQL Server Management Studio. However, when you need to do something, Read More... Posted Sunday, March 11, 2007 10:50 PM by Marco Russo (SQLBI) | 1 Comments Filed under: SSIS

• How to get Distinct Count in SSIS

  Almost one month ago I made a post about a brand new Distinct component for SSIS made by Alberto Ferrari and freely available on SQLBI.EU . The most used way to get distinct rows in a Data Flow that I've seen is to use the Sort component, asking only Read More... Posted Friday, March 9, 2007 9:06 PM by Marco Russo (SQLBI) | 0 Comments Filed under: SSIS, Distinct

• SSAS 2005 SP2 breaks Excel calculated member selection

  After many tries, today I came to the conclusion that Analysis Services 2005 SP2 breaks the Excel 2007 calculated member selection feature. I already talked about this issue here , but today I found the way to reproduce the error. This is a scenario that Read More... Posted Wednesday, March 7, 2007 10:25 PM by Marco Russo (SQLBI) | 5 Comments Filed under: Analysis Services, PivotTable, SSAS SP2, Excel 2007