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

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 project should run perfectly after this.

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

Pass parameter to SQL Queries statement using Power BI

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 then the SQL Queries will be Dynamic instead of
Static.

The video is for any developers especially for Power BI developers or Excel Dashboard creators.

This is level 300

https://channel9.msdn.com/Blogs/MVP-Azure/Pass-parameter-to-SQL-Queries-statement-using-Power-BI

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

Hyper-V in Windows Creator Updates 1703

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 a nightmare using 8GB machine to run a Hyper-V Virtual Machine with 5GB. I had to start my VM once I started my machine. The Hyper-V would complained the memory was insufficient to start the VM even though I closed all my browsers and applications if I did not start it right away after I started my machine.

I realized this is not a problem in Windows 10 1703. I can start my 5GB memory VM after I closing all the applications that I was running. My VM configuration as below.


If you are struggling with starting your VM with limited memory in Win 10 then have a try in Windows 10 1703.

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

SSIS Cannot cast division to float DT_R8 using Derived Column

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 (DT_R8)(ttMove / 60).

You need to remove the parenthesis () in order to get 7.75. So the right Expression should be (DT_R8)ttMove / 60 .

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’.

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 SSIS and I got the following message.

Unable to cast COM object of type ‘System.__ComObject’ to interface type ‘Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSVariables100’. This operation failed because the QueryInterface call on the COM component for the interface with IID ‘{D1A469BC-F371-4D15-832F-BACB50C162E9}’ failed due to the following error: The application called an interface that was marshalled for a different thread. (Exception from HRESULT: 0x8001010E (RPC_E_WRONG_THREAD)).

Again, the message did not make any sense to anyone. So I tried to set the TargetServerVersion property for SSIS Project. Somehow, it was working fine.

Do not just follow me and set SQL Server 2014. You must know the version of SQL Server that you are using.

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

SSIS Connection property has not been initialized

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 is added like below.

In the Script Component C# code you have the following.

public override  void AcquireConnections(object Transaction)

{

   ConMgr = this.Connections.ConnectionQc;

   Targetconnection = this.Connections.ConnectionQc.AcquireConnection(null);

   SqlConn = Targetconnection as SqlConnection;

}

When you run then you get the error “Connection property has not been initialized”.

What is wrong here is that your Package Connection Manager could be using

Native OLDE DB\SQL Server Native Client 11.0

Change the Connection Manager Provider to

.Net Providers\SqlClient Data Provider

This will resolve your problem if you are having the same scenario as I do.

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

What is Windows 10 Creators Update

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/,  it has written “We are excited to announce that today, the Windows 10 Creators
Update has started rolling out to Windows 10 customers around the world as a  free update.” And again it didn’t say where to get a copy of Windows 10  Creators edition.

Then I came to another website “Windows 10 Creators  Update review: Microsoft adds fun to its flagship OS” and again when to get this  Windows 10 Creators Update.

Finally, I get this link https://support.microsoft.com/en-us/help/4014916/windows-10-choose-your-privacy-settings-for-windows-10-creators-update resolve my question.

Windows 10 Creators Update (also known as Windows 10, version 1703). You can find Windows 10, version 1703 in  MSDN.

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