Category Archives: Data Platform

‘Add-AzureAccount’ is not recognized as the name of a cmdlet

This post is giving you one of the solutions to resolve “‘Add-AzureAccount’ is not recognized as the name of a cmdlet” error message. In many Internet solution the will ask you to type the following command. Install-Module AzureRM -AllowClobber, This … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged | Leave a comment

SQL Server Auto Shrink not working then how to Shrink

Let’s put aside the performance problem. The Auto Shrink in SQL Server work after all. When you go into a database properties then you will see the Auto Shrink property like the one below. I was searching everywhere and the … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged | Leave a comment

SSIS Unable to cast COM object of type ‘System.__ComObject’ to class type ‘System.Data.SqlClient.SqlConnection’.

This post giving one of the possible solution to resolve the error above. You have a Script Task in SSIS and utilizing the Connection Manager. The Connection Manager Provider type is Native OLE DB\SQL Server Native Client 11.0. You have … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged , | Leave a comment

Digital Transformation in a nutshell

This article is about digital transformation. After researching on the Internet there is fewer solid articles on digital transformation. What is not digital transformation Buying a lot of IoT devices working on a silo way, putting up the servers to … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform, Office 365, sharepoint | Tagged | Leave a comment

SSIS SharePoint Data Source

This post shows you how to use Office 365 SharePoint as data source in SSIS Data Flow. Pre-requisite: 1. You already have basic knowledge on SSIS. 2. You have installed SharePoint SDK to your development environment https://chanmingman.wordpress.com/2018/10/07/ssis-could-not-load-file-or-assembly-microsoft-sharepoint-client/ 3. SQL Server … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged , | Leave a comment

SSIS Could not load file or assembly ‘Microsoft.SharePoint.Client

This post shows you one of the possibilities your SSIS cannot load the Microsoft.SharePoint.Client dll. When you wanted to connect to SharePoint Online in your SSIS project then you copied Microsoft.SharePoint.Client and Microsoft.SharePoint.Client.Runtime to a folder and point your Script … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform, Office 365 | Tagged , , | 1 Comment