SQL Server Data Tools Archives - Reporting/Analytics Made easy with FourMoo and Power BI

Tag: SQL Server Data Tools

SQL Server Integration Services (SSIS) – Using Send Mail Task for data validation checks

by Gilbert Quevauvilliers June 20, 2014

What I wanted to do was to be notified in my data if there were not enough rows of data, or if the financials were too low, indicating that there was a potential issue with the data coming in. And if it was too low to fire off an email. If it was correct then to not send an email….

Uncategorized 0

SSAS – Error – Value cannot be null. Parameter name: rootComponent

by Gilbert Quevauvilliers March 18, 2014

I got the following error as shown below, when I was adding rows into the XML file for the Data Source View. NOTE: The reason that I was using the XML file was because I had added a whole lot of partitions to my Data Source View, so I did not want to create all the relationships manually but rather…

SQL Server Analysis Services OLAP, SSAS 0

Tag: SQL Server Data Tools

SQL Server Integration Services (SSIS) – Using Send Mail Task for data validation checks

SSAS – Error – Value cannot be null. Parameter name: rootComponent

Recent Posts

Tags