1. How to solve AppFabric Server installation error.
you can resolve by modifying the PSModulePath environment variable
manually in Control Panel->System->Advanced System
Settings->Advanced tab->Environment Variables->system
variables. then remove the double quotation.
2. How to fix Application Server Role, Web Server(IIS) Role Configruation error.
go to windows\system32 directory.
then just make duplication for the servermanager.exe and then rename to servermanagercmd.exe
Thursday, June 18, 2015
Wednesday, June 10, 2015
Tips on increase Fuzzy Grouping analysis Performance in SSIS Integration Servicce
currently i am using the Fuzzy Group Analysis in SSIS to identify the duplicated record in the AS400 Main Frame. I try to summarize couples things that i believe they will help if you need to perform the same task.
1. please select all necessary columns from the file in the subfiles and import them into the sql server.
this approach will reduce the time on extracting data from AS400.
2. run the fuzzy group analysis against the data from SQL server instead of loading them directly from AS400. this step had save me significant amount of time when i need to analysis more than million rows of records.
3.use IBM i Access for Windows ODBC data driver to increase the data extract performance. it is fast more better than Microsoft Windows Default ODBC driver.
4.Always use the refresh button from the Advance Edit Windows on each component to refresh the data mapping.
1. please select all necessary columns from the file in the subfiles and import them into the sql server.
this approach will reduce the time on extracting data from AS400.
2. run the fuzzy group analysis against the data from SQL server instead of loading them directly from AS400. this step had save me significant amount of time when i need to analysis more than million rows of records.
3.use IBM i Access for Windows ODBC data driver to increase the data extract performance. it is fast more better than Microsoft Windows Default ODBC driver.
4.Always use the refresh button from the Advance Edit Windows on each component to refresh the data mapping.
Monday, June 1, 2015
How to integrate .net framework 4.5.2 into Visual studio 2013
when i worked with my teammate on the project that setup by him.
I was unable to open the project and compile it. the error message indicate that i did not have .net framework 4.5.2 installed. although i had installed the .Net Framework 4.5.2 via offline installer.
unfortunately, that is not the correct package for visual studio 2013.
we must have Microsoft .Net Framework 4.5.2 Developer Pack installed, so that we can have .NET Framework 4.5.2 Multi-Targeting Pack: Contains the reference assemblies needed to build apps that target the .NET Framework 4.5.2.
you can download the developer package via this link
https://www.microsoft.com/en-us/download/confirmation.aspx?id=42637
you can also select your specific .net framework from the following link
Installing the .NET Framework
I was unable to open the project and compile it. the error message indicate that i did not have .net framework 4.5.2 installed. although i had installed the .Net Framework 4.5.2 via offline installer.
unfortunately, that is not the correct package for visual studio 2013.
we must have Microsoft .Net Framework 4.5.2 Developer Pack installed, so that we can have .NET Framework 4.5.2 Multi-Targeting Pack: Contains the reference assemblies needed to build apps that target the .NET Framework 4.5.2.
you can download the developer package via this link
https://www.microsoft.com/en-us/download/confirmation.aspx?id=42637
you can also select your specific .net framework from the following link
Installing the .NET Framework
Subscribe to:
Posts (Atom)