Category Archives: .Net

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

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

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 , , , | 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/, Continue reading

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

Enable and Disable Proxy in IE using command

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

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

SSAS cannot find database after deploy

This short blog shows you where to find the SSAS database that you deployed. After you deployed the SSAS cube in Visual Studio and you started SQL Server Management Studio then choose Analysis Services. You did not get to see … Continue reading

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