Windows 10 Start Menu not working

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 to this page https://www.cnet.com/how-to/how-to-fix-the-windows-10-start-menu/ and click This link will take you directly to the download.

This link http://www.thewindowsclub.com/start-menu-does-not-open-windows-10 is completely hopeless.

I re-uploaded the utility here: https://1drv.ms/f/s!AuZYHSwsevw1hCgMh9mcnNJ7Yz1L

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

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 Tool and it keep giving you an error “The tool was unable to download Microsoft Sync Framework Runtime v1.0 SP1 (x64)” as below.

One of the key reason is, you have not disabled the IE Enhanced Security Configuration.

 

 

 

 

 

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

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 operating system, and virtual machines (VMs) with just-in-time administration and shielded VMs
  
• Improve datacenter efficiency with virtualization, software-defined storage, and networking
  
• Deliver application innovation with improved security, new modernization capabilities, and cloud-native app development
  

https://info.microsoft.com/rs/157-GQE-382/images/HybridCloud_WS_UltimateGuidetoWindowsServer2016.pdf

SSIS Web Service Task Download WSDL

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 I get the wsdl file?

If you follow this link https://docs.microsoft.com/en-us/sql/integration-services/control-flow/web-service-task-editor-general-page  to download the wsdl file then you will get yourself kill.

I am not sure able Java Web Service but for Web  Services that created using Visual Studio then you can get the wsdl file by  adding ?WSDL at the back of asmx for example you have the following  link:

http://52.163.113.178/uCustoms/WSuCustoms/WebServiceATA.asmx

in order to get the wsdl then you will do:

http://52.163.113.178/uCustoms/WSuCustoms/WebServiceATA.asmx?WSDL

Save the file as wsdl then point your Web Service Task  Editor to it.

Reference:

https://www.codeproject.com/Articles/823657/Using-SSIS-To-Get-Data-From-a-Web-Service

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

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 the forums. For example like the one below.

http://stackoverflow.com/questions/10851273/why-integer-division-in-c-sharp-returns-an-integer-but-not-a-float

Means the code below might not work for you.

static void Main(string[] args)

{

    float f1 = 0;

    float f2 = 0;

    float f3 = 0;

 

    f3 = (f1 / f2) * 60;

}

There are 2 solutions:

1. change the code

f3 = (f1 / f2) * 60f;

2. Update you Visual Studio to Update 3 if you are using Visual Studio 2015.

Column data type DT_WSTR is not supported by the PipelineBuffer class

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 was saying cast this DT_STR to DT_WSTR and so but that all were helpless.

The actual fact in my situation was I checked how SSIS defined the Excel column. Realized is
String.

public
String T0700

{ get 

   {

       return Buffer.GetString(BufferColumnIndexes[1]);

    }

}

Somehow my code is using
string.

public
string OperatorID { get; set; }

I resolve this by changing my code
string
to
String.

SSIS Read Excel Text value become NULL

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 the Numeric value become NULL value. Somehow that resolve my problem as well..

I am running this in 32 bit.

My original connection string as below from the Excel Connection Manager.

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\dev\ptp\bi\Incentive\QC\JUN2017\01.xlsx;Extended Properties=”EXCEL 12.0 XML;HDR=YES;

I add the IMEX=1 into the connection string as below.

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\dev\ptp\bi\Incentive\QC\JUN2017\01.xlsx;Extended Properties=”EXCEL 12.0 XML;HDR=YES;IMEX=1“;

Reference:

https://www.kasperonbi.com/import-excel-in-ssis-and-get-null-values-in-stead-of-numeric-values/