A quick post to see how to launch an SSRS subscription from SSIS.
It can be used as in my case for example to send by mail a report on the execution status of an SSIS package. Of course after inserting the logs of this package in a table, create a restitution report of these logs as well as a subscription which sends the report by email.
So how?
Read More Run an SSRS subscription with SSIS
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?
Last week, I passed my final exam to acquire the MCSE BI, I would like to share with you this feedback especially on my preparation for all the exams, this is not a strict guideline of course, but it is is just what was best for me.
The MCSE certification consists of taking 5 separate exams: the first 3 give you the MCSA SQL Server certification:
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