October 2005 - Posts

• SSIS: how to migrate Data Transformation Task of a DTS

  As you already know, the DTS migration wizard of SSIS 2005 doesn't migrate Data Transformation Task in a Data Flow component, but instead it uses to encapsulate each Transformation Task into a legacy embedded DTS 2000 package. Now, you can imagine my Read More... Posted Monday, October 31, 2005 5:04 AM by Marco Russo (SQLBI) | 0 Comments

• AS2000 magics: working without repository

  Today I discovered that you can have a working AS2000 database without repository data relative to structure internals to that database (cubes and dimensions). Just to explain how it works. You have a "Foodmart 2000" database Into the Olap Data directory, Read More... Posted Friday, October 07, 2005 10:14 AM by Marco Russo (SQLBI) | 0 Comments

• Star schema vs. snowflake with SSAS2005

  Recently I discovered that a very large dimension could be loaded more effectively by SSAS2005 if it is designed as a snowflake schema instead than as a singular table (star schema). I have to say that I'm a strong supporter of star schema, but these Read More... Posted Friday, October 07, 2005 7:13 AM by Marco Russo (SQLBI) | 0 Comments

• SSAS2005 connection via HTTP

  A short post to link this article: Configuring HTTP Access to SQL Server 2005 Analysis Services on Microsoft Windows Server 2003 . Very useful: I haven't found a clear description for this task in Books On Line (but, we know, beta documentation is not Read More... Posted Saturday, October 01, 2005 5:44 AM by Marco Russo (SQLBI) | 0 Comments