Monthly Archives: December 2017

The problem of using var to declare variable

Posted on December 30, 2017 by chanmingman

People just over use var to declare variable. var is good if you have a statement like var result = from r in someList; It will be very bad to use var like the example below from https://magedfarag.wordpress.com/2012/12/14/call-wcf-sevice-using-only-webclient-and-soap-xml/ (if the … Continue reading →

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

The Developer’s Guide to Microsoft Azure SECOND EDITION FREE

Posted on December 29, 2017 by chanmingman

This is a book that without advertisement. A lot of walkthroughs, provided the Azure portal still look the same because Microsoft keep changing the Azure interface. Sometime you just do not know where the items that you want or in … Continue reading →

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

IIS The process cannot access the file because it is being used by another process

Posted on December 27, 2017 by chanmingman

This short writing shows you one of the possible ways to resolve the error “The process cannot access the file because it is being used by another process. (Exception from HRESULT: 0x80070020)” This error prevent you from starting IIS Website. … Continue reading →

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

SSIS Parameter name is unrecognized

Posted on December 24, 2017 by chanmingman

This short article shows you one of the ways to resolve the error “Parameter name is unrecognized”. You have Execute SQL Task in your Data Flow. You want to pass in variable as parameter so you have a sql statement … Continue reading →

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

SQL Server Data Tools for Visual Studio 2017

Posted on December 21, 2017 by chanmingman

This shot writing is letting you know SQL Server Data Tools for Visual Studio 2017 is RTM. You can get this SSDT here https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt. No need to go to your msdn and look for the iso file for now. It … Continue reading →

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

Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: Could not execute the Web method

Posted on December 20, 2017 by chanmingman

This short blog shows you how to resolved the error “Could not execruute the Web method. The error is: Could not load file or assembly ‘Microsoft.SqlServer.WebServiceTask” when running SSIS in Visual Studio 2015 with SSDT SSDT_14.0.61707.300_EN. When you add a … Continue reading →

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

Cisco VPN 5.0.0.7 Windows 10 1709

Posted on December 18, 2017 by chanmingman

This short blog show you how to resolved the issue of Cisco VPN 5.0.0.7 Windows 10 1709. Once you have done the auto update to Windows 10 1709 then you will realize Windows 10 removed your Cisco VPN Service without … Continue reading →

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

C# Generating, duplicating, inner XML data for testing

Posted on December 14, 2017 by chanmingman

For most integration projects people will use XML as the communicate messages. This utilities will generate and populate the repeating part of the XML as many as you want to use. In the following example, you want to duplication the … Continue reading →

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

SSIS Control Flow Conditional

Posted on December 9, 2017 by chanmingman

This short blog showing you how to create conditional in SSIS Control Flow. 1. Drag Script Task to your Control Flow. 2. Put another two of any component in the Control Flow. For here, you can see I have one … Continue reading →

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

SSIS Loop XML files in folder

Posted on December 5, 2017 by chanmingman

This short blog is showing you how to loop through the XML files in a folder using SSIS. This is modified from http://www.sqlis.com/post/Looping-over-files-with-the-Foreach-Loop.aspx. Below highlight the key elements for the loop. At first, do have varFileName and varSourceFolder variables, and … Continue reading →

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