Dynamic Partition Management SSAS - 2 Part

Here we are in the 2th part of this article where there is less blah blah but more practice (putting our hands in the leg !!)

In this part, I will explain the steps to follow step by step to create the cube partitions in a dynamic way.

  • Step 1 :

First, prepare the test data, for that, we will work with the database and the cube AdventureWorksDW, you can download the sources as well as the deployment scripts from the links below:

Read More Dynamic Partition Management SSAS - 2 Part

Set up a lookup

Using a parameterized query in a lookup can lighten the cached data, especially in the case of iterative processing, and you do not have to load all the data into the cache.

Even though the lookup component does not offer the ability to use variables but it does have the property SqlCommand which allows to specify the query of the lookup and that can be parameterized.

Read More Set up a lookup

Run an SSRS subscription with SSIS

A quick post to see how to launch an SSRS subscription from SSIS.

It can serve as in my case for example to email a report on the execution status of an SSIS package. Of course after inserting the logs of this package in a table, create a report of return of these logs and a subscription that sends the report by mail.

So how?

Read More Run an SSRS subscription with SSIS