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

How to create your own SSRS card?

As part of the BI project I'm currently working on, I needed to render my data on a map of several gold countries on visual studio, we found that the map of the United States, so how to do for other countries?

Here is a solution to create our own personalized map.

Read More How to create your own SSRS card?

Feedback (MCSE BI)

Last week, I passed my final exam to acquire the MCSE BI, I want to share with you this feedback especially on my preparation for all exams, it is not a strict guideline of course, but it just what was best for me.

The MCSE certification consists of passing 5 separate exams: the first 3 give you the MCSA SQL Server certification:

Read More Feedback (MCSE BI)

Conditioning the visibility of SSRS columns

In this article, I'm going to show you a real-life example of using the visibility property (Visibility) of the column in SSRS.

Visibility property of the column is used to show or hide the column in the report. Now, in this article, we can use this property to allow users to select the columns they want to display in a report instead of all the columns.

Read More Conditioning the visibility of SSRS columns