Monthly Archives: February 2018

Microsoft Power BI vs Qlik vs Tableau 2018

Gartner 2018 reports shows Tableau, Qlik, and Microsoft are the leader in Analytics and Business Intelligence Platforms. The full Gartner url is at the bottom. The Gartner link will be expired in sometime later, that was my experience with Gartner … Continue reading

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

Outlook display receiver instead of sender in folder

This post show you how to change the Outlook folder to display receivers instead of senders. This is for Outlook 2013. Go to VIEW tab. Click View Settings. Click Columns. Select From in Show these columns in this folder. Click … Continue reading

Posted in Microsoft Office, Office 365 | Tagged , , | Leave a comment

SSIS Web Service Task Unable to connect to the remote server

This blog post shows one of the possibilities to resolve the error below in SSIS Web Service Task [Web Service Task] Error: An error occurred with the following error message: “Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: The Web Service threw an error during method execution. … Continue reading

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

SSIS Web Service Task Client found response content type of ‘text/plain; charset=utf-8’, but expected ‘text/xml’

This blog post shows you one of the ways to resolve the error “The Web Service threw an error during method execution. The error is: Client found response content type of ‘text/plain; charset=utf-8’, but expected ‘text/xml’.” when you are calling … Continue reading

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

SSIS Script Task System.RuntimeMethodHandle.InvokeMethod

This blog post shows one of the possibilities to resolve SSIS error “at System.RuntimeMethodHandle.InvokeMethod” when using Script Task. I have the below code in my SSIS Script Task: ConnectionManager cm; cm = Dts.Connections[“uCustoms”]; SqlConnection sqlConn; sqlConn = (SqlConnection)cm.AcquireConnection(Dts.Transaction); cm.ReleaseConnection(sqlConn); This … Continue reading

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

How to unlock your USB ports

This blog shows you how to unlock your USB port if it is locked by your group policy. First, you need to disable the group policy following this link: https://chanmingman.wordpress.com/2015/07/22/disable-group-policy/ To unlock USB you must have local administrator privilege. Run … Continue reading

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

Update XML Node value using C#

This blog show you the sample code to update the XML file content. Let say we have the following XML file. <?xml version=”1.0″ encoding=”utf-8″ ?> <Vessel>     <IMO>392060</IMO>     <SCN>1234567890123</SCN>     <VesselId>6535</VesselId> </Vessel> To get the XML … Continue reading

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