Monthly Archives: October 2018

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

Posted on October 30, 2018 by chanmingman

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

Posted on October 27, 2018 by chanmingman

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

The type name ‘ServiceReference1′ does not exist in the type ‘someclass’

Posted on October 25, 2018 by chanmingman

The post shows you on of the ways to resolve “The type name ‘ServiceReference1’ does not exist in the type ‘someclass’” error. Not sure for what reason Visual Studio having this problem lately. When you reference a Service Reference, for … Continue reading →

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

How to Trim Video

Posted on October 21, 2018 by chanmingman

This shortest post show you one of the ways to trim you video. I have been search a way to cut my video, and VLC appearing everywhere on my search but I have a serious problem with VLC player. After … Continue reading →

Posted in Community, Computers and Internet | Tagged | Leave a comment

Postman LinkedIn Access Token

Posted on October 17, 2018 by chanmingman

The blog shows you one of the ways to get the Access Token from LinkedIn by using Postman. I spent 2 days to get this correct so you don’t have to spend 2 days. Firstly, you need to get to … Continue reading →

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

SSIS SharePoint Data Source

Posted on October 12, 2018 by chanmingman

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

Posted on October 7, 2018 by chanmingman

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 , , | 3 Comments

Cyber attacks on seaports

Posted on October 6, 2018 by chanmingman

This post highlights the Cyber attack involve 4 well known seaports in the world. Below are the links to the Maersk, COSCO, Port of Barcelona, Port of San Diego Cyber Attack. Moller-Maersk puts cost of cyber attack at up to … Continue reading →

Posted in Community, Computers and Internet | Tagged | Leave a comment