Monthly Archives: July 2017

Cannot find wrapper assembly for type library “Microsoft.Office.Core”

Posted on July 29, 2017 by chanmingman

This short blog shows you how to remove the error “Cannot find wrapper assembly for type library “Microsoft.Office.Core””. Make sure you have Microsoft Office installed, for me is version 2013. The right click on the Microsoft.Office.Core and Remove it. You … Continue reading →

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

Pass parameter to SQL Queries statement using Power BI

Posted on July 27, 2017 by chanmingman

This video shows you how to pass parameters to SQL Queries statement using Power BI. It is not straightforward to pass parameters  to the SQL Queries statement in Power BI Desktop. Enable the parameters passing  on the SQL Queries statement … Continue reading →

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

Hyper-V in Windows Creator Updates 1703

Posted on July 24, 2017 by chanmingman

I am just sharing one of the key improve of Windows 10 1703 also known as Windows Creator Updates that I like. Not many people will be affected by this feature beside those IT Pro and Developers. I always have … Continue reading →

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

SSIS Cannot cast division to float DT_R8 using Derived Column

Posted on July 19, 2017 by chanmingman

This short blog shows you why you cannot cast the division or int float DT_R8 using Derived Column. I have a column ttMove is Integer and the value is 465. So, 465/60 should be 7.75. I was putting the Expression … Continue reading →

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

Unable to cast COM object of type ‘System.__ComObject’ to interface type ‘Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSVariables100’.

Posted on July 18, 2017 by chanmingman

This shows you how to resolve the error “Unable to cast COM object of type ‘System.__ComObject’ to interface type ‘Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSVariables100’.” in SSIS. This message actually does not make any sense to anyone. I was looping through my Excel Worksheet in … Continue reading →

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

SSIS Connection property has not been initialized

Posted on July 15, 2017 by chanmingman

This short blog showing you one of the possibilities to resolve the error message “Connection property has not been initialized” when using the Script Component in SSIS package. In SSIS package, the Script Component is added, and the Connection Manager … Continue reading →

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

What is Windows 10 Creators Update

Posted on July 12, 2017 by chanmingman

I was looking for Windows 10 Creator edition as  mentioned in Microsoft Build 2017. Hence, I was finding a copy of Windows 10 Creators in  MSDN subscription but unfortunately I could not get this edition. I was read this link, https://blogs.windows.com/windowsexperience/2017/04/11/whats-new-in-the-windows-10-creators-update/,  … Continue reading →

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

Enable and Disable Proxy in IE using command

Posted on July 9, 2017 by chanmingman

This short blog show you how to Enable and Disable Proxy in IE using command Despite Chrome and Edge claim the best browser but in Windows environment there yet need to rely on IE to set the proxy. It is … Continue reading →

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

SSIS Loop Excel Workbook

Posted on July 4, 2017 by chanmingman

This blog is to show you how to loop through an Excel Workbook using SSIS. To loop through Excel in SSIS you need some tips and  tricks. The expectations of this article are: 1. You have installed SQL Business Intelligence Development Studio (BIDS) … Continue reading →

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