SQL Server Integration Services (SSIS) – Using Send Mail Task for data validation checks
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….
SSAS – Error – Value cannot be null. Parameter name: rootComponent
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…