• I feel relaxed and excited my applications has successfully passed a 3 years working tool. It is a fully automated ETL, Data mining and Data warehouse system. It consumes a multiple daily data sources (zipped files at FTP and Json at a RESTful webserver) and process and store for more than 120 columns for the business requirement. All processes are automatic! It is a 30,000 lines VBA codes, 10,000 line TSQL code and working MySQL Server. ADO is the most technology used in the applications with a few uses of bat scripting (ohh... I learnt this from 15 years ago), vbscripting, lotus notes class etc. It is beyond SSIS and SSAS capabilities. A wise man (BS) says 'There are no “cookbook” methods that can replace intelligence, experience, and good taste in design and programming'. Aha that man is very true and I did it for fun.

    Well I told my kid and my mum that I have made a robot. Yes this robot is very productive and diligent compared to human being, but sometime it is clever than me as well. I hate a salesman who keeps preaching me that SSIS and SSAS is the best way and every day he pushes/or executes buttons so many time to get things done and never realizes he is a robot. The good thing is this robot has stopped him preaching me out.