databasejournal.com databasejournal.com

MSSQL Server Reporting Services : Mastering OLAP Reporting: Drilling Through Using MDX

About the Series ... This article is a member of the series MSSQL Server Reporting Services. The series is designed to introduce MSSQL Server Reporting Services ("Reporting Services"), with the objective of presenting an overview of its features, together with many tips and techniques for real-world use. For more information on the series, as well as the hardware / software requirements to prepare for the exercises we will...

databasejournal.com databasejournal.com

SQL Server 2005 - SQL Server Integration Services - Part 5

In the previous article of this series, we started reviewing two new types of containers introduced in the SQL Server 2005 Integration Services - For Loop and Foreach Loop. We also provided a simple example illustrating the use of Foreach File enumerator. We will continue our review of Foreach enumerators starting with Foreach ADO, since this one probably qualifies as the most popular choice in its category. This is due to the fact...