How to move data from Excel to SQL Server 2008/2012- Act 1 Scene 3

A hands on activity showing pictorial steps on how to dynamically move data from excel files to text files using SQL Server Data Tools (SSDT) and BIDS 2008

Error: Python version 2.7 required, which was not found in the registry- Solved

Today while installing, scipy for Python ver 2.7 I came across this error message on my Windows 7 OS 64 bit system. Please note, I already have Python 2.7 installed. The solution is; 1. Open notepad and copy paste the following code in it. [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Python] [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Python\PythonCore] [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Python\PythonCore\2.7] [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Python\PythonCore\2.7\Help] [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Python\PythonCore\2.7\Help\Main Python Documentation] @=”C:\\Python27\\Doc\\python276.chm” [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Python\PythonCore\2.7\InstallPath] @=”C:\\Python27\\” [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Python\PythonCore\2.7\InstallPath\InstallGroup]…

Data Processing with Weka (Part II)

Today, I will discuss and elaborate on data processing in Weka 3.6 (it’s the same in version 3.7 too). This post is the second part in the series of “Data pre-processing with Weka”. If you have not seen my earlier post, you are directed to see that first. Continuing further, assuming that you have cleaned…