Monthly Archives: August 2017

SSIS Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80040154 Class not registered

Posted on August 28, 2017 by chanmingman

This short blog shows you how to resolve another not so meaningful error message that you will encounter if your SSIS package is connecting to Excel. When you look at the error message below then what action should you take? … Continue reading →

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

SSIS The version of Script Derived Status is not compatible with this version of the DataFlow

Posted on August 24, 2017 by chanmingman

This short blog shows you how to resolve a long meaningless error from SSIS. When you put your SSIS package to run by the SQL Server Job Agent. Then you got the error below. The message is long and not … Continue reading →

Posted in .Net, Community, Computers and Internet | Tagged | 1 Comment

Windows 10 Start Menu not working

Posted on August 17, 2017 by chanmingman

The short blog let you know one of the ways can resolve this issue. Fortunately, I found so many link and only this one working for me even though it said “Not fix” at this end running the utility. Go … Continue reading →

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

SharePoint The tool was unable to download Microsoft Sync Framework Runtime v1.0

Posted on August 15, 2017 by chanmingman

This short blog shows you one of the possible way to resolve the error “The tool was unable to download Microsoft Sync Framework Runtime v1.0 SP1 (x64)” when installing SharePoint 2016. When you are running the SharePoint 2016 Product Preparation … Continue reading →

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

E-book download – The Ultimate Guide to Windows Server 2016

Posted on August 11, 2017 by chanmingman

E-book download – The Ultimate Guide to Windows Server 2016 Download the free e-book to learn about the latest technology in Windows Server 2016 and what it means for your organization. Inside you’ll learn how to: Better protect credentials, the … Continue reading →

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

SSIS Web Service Task Download WSDL

Posted on August 9, 2017 by chanmingman

This short blog shows you where to get the wsdl file  for the Web Service Task in SSIS. Once you created a HHTP Connection Manager for your Web Service then you will be in the myth on where the hell can … Continue reading →

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

Integer division in c# returns an integer but not a float

Posted on August 8, 2017 by chanmingman

This short blog shows you one of the possibilities to resolve the error Cannot implicitly convert type `float’ to `int’. “” I found people asking “Why Integer division in c# returns an integer but not a float?” and more in … Continue reading →

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

Column data type DT_WSTR is not supported by the PipelineBuffer class

Posted on August 2, 2017 by chanmingman

This short blog shows you one of the possibilities to resolve the error “Column data type DT_WSTR is not supported by the PipelineBuffer class” when you read from Excel to Database through SSIS I have been searching the web, people … Continue reading →

Posted in .Net, Community, Computers and Internet | Tagged , , | 1 Comment

SSIS Read Excel Text value become NULL

Posted on August 1, 2017 by chanmingman

The short blog shows you how to resolve the problem when you use SSIS to import Excel file but the Text value become NULL value. I found a link to add IMEX=1 to resolve SSIS to import Excel file but … Continue reading →

Posted in .Net, Cloud, Community, Microsoft Office | Tagged , , , , | Leave a comment