Posts

SSIS Extract Zip file using System.IO.Compression

-
Image
The  System.IO.Compression  namespace contains the following types for compressing and decompressing files  and streams. You can also use these types to read and modify the contents of a compressed file: To get more about the System.IO.Compression you may visit the detail page from MSDN website. https://msdn.microsoft.com/en-us/library/ms404280(v=vs.110).aspx This demo is for those ETL developers want to use .net build-in compression library and to focus on their main task instead of digging through the internet and spending time searching for sample code using other third party library like 7zip and WiRar . Please do take note that your production Integration Services Server must have .Net Framework 4.5 or later. The following demo will show you how to use .net  System.IO.Compression  library to help you extract zip file in your SSIS project and for this short demo we will only use " ExtractToDirectory " method . Create working directory for yo
Post a Comment
Read more

Error in smtp gmail using c#.net

-
Image
For some of you encountering error using C#.net and gmail smtp server " The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.5.1 Authentication Required. Learn more at ". Error in C# code Your GMail account settings for " Access for less secure apps " is blocked by default and you may enable this by changing the settings  below. 1. Login to your Gmail account and click the " Settings " icon at the upper right side of the corner. 2. Click the " Accounts and Import"   and click the " Other Google Account Settings" 3. Click the " Access for less secure apps" ( if the settings is "Blocked" ) 4. Select the " Turn on " radio button.  Re-run your c# code and check the recipient email. Note: By turning on the Gmail Settings, you are setting your email account in less
1 comment
Read more

Download TeamViewer version 6

-
Hi All, I would like to share the link where you can download the TeamViewer version 6. Maybe some of your partner are still using the version 6 because they are unable to update their version due to the license issue. The free version of TeamViewer are very useful and enough for normal user like me who always love helping others to solve their simple computer troubleshooting. Download Page: https://www.teamviewer.com/en/download/dyngate.aspx#version6
Post a Comment
Read more