Latest Power BI and AI articles from RADACAD team
This Video Tutorial illustrates how to use Nodelist enumerator to loop through an XML content with Foreach Loop structure. Nodelist uses XPath query language for interating through nodes, elements, attributes of an xml content, that might come from file, variable, or static string. In this sample we call a web service to select name of Read more about Foreach Loop : NodeList Enumerator – SSIS 2012 Tutorial Videos[…]
This Video Tutorial starts with an introduction to Contianers in SSIS 2012, then it explains different kind of enumerators in foreach loop contianer. Finally this video will focus on File Enumerator, and shows an example of loading multiple CSV files into a destination table. In the example you will learn how to implement a loop Read more about Foreach Loop Container : File Enumerator – SSIS 2012 Tutorial Videos[…]
This is a common error in SQL Server Analysis Services (SSAS). when you deploy the project to SSAS Server, you might face this error. Reason: There are some user/group membership added to roles in SSAS project, that is not matching with Active Directory user/groups. for example you might find some membership entries with GUID listed Read more about SSAS Deployment Error: No Mapping between Account Names and Security IDs was Done.[…]
I am delighted to say that I will speak at this year’s Pass Summit 2013 in NC Charlotte. Session that I will speak on it is: SSIS Package Failed in Production? Here’s How to Troubleshoot This will be my first attendance in Pass Summit and I am looking forward to see many of you, and Read more about I am speaking at Pass Summit 2013[…]
Last week I’ve talked with Greg Low from SQL Down Under, and Greg published the podcast talk in his website. I really appreciate Greg’s idea an hard work on podcast shows series on his website. I enjoyed when I read podcasts from many SQL Server MVPs about their area of expertise. I strongly recommend to Read more about SQL Down Under Pod Cast[…]
In a multi environment system which you might have Development, UAT and Production for your master data services, the requirement for transfer MDS models across different master data services will be sensible. sometimes you just need to transfer model structure (metadata) from one server to another, but in some situations you will need to have a Read more about MDS: Deploy Master Data Services Model with Data From One Server to Another[…]
Thank you all for attending at my presentation in TechDays 2013 Hong Kong at evening of 3rd day of conference. here you can find presentation file of my speaking session about Knowledge Driven Data Quality with DQS and Microsoft SQL Server 2012 Title: Knowledge Driven Data Quality with DQS and Microsoft SQL Server 2012 Description: Read more about Presentation files for Hong Kong TechDays 2013 : Knowledge Driven Data Quality with DQS and Microsoft SQL Server 2012[…]
Thank you all for attending at my presentation in TechDays 2013 Hong Kong at morning of 3rd day of conference. here you can find presentation file of my speaking session about Choosing the right Visualization Tool with Microsoft Business Intelligence Title: Choosing the Right Visualization Tool with Microsoft Business Intelligence (MSBI) Description: Microsoft BI stack Read more about Presentation files for Hong Kong TechDays 2013 : Choosing the Right Data Visualization with Microsoft Business Intelligence[…]
Thank you all for attending at my presentation in TechDays 2013 Hong Kong at 2nd day of conference. here you can find presentation file of my speaking session about SQL Server Analysis Services Tabular Modelling Title: SQL Server Analysis Services Tabular Modelling Description: SQL Server 2012 provided another method for modelling BI presentation named SSAS Tabular Modelling. Read more about Presentation files for Hong Kong TechDays 2013 : SSAS Tabular Modeling[…]
If you faced this error when you want to connect Data Quality Services (from Data Quality Client or from SSIS DQS Cleansing component); Cannot connect to server – A .NET Framework error occurred during execution of user-defined routine or aggregate “SetDataQualitySessions” – SetDataQualitySessionPhaseTwo You can fix it in following way; Why this happens: When .NET Framework Read more about DQS Error : Cannot connect to server – A .NET Framework error occurred during execution of user-defined routine or aggregate “SetDataQualitySessions” – SetDataQualitySessionPhaseTwo[…]