Tuesday, September 15, 2015

SSIS Log Simplifier

Here's a simple tool made on winforms that will help you simplify the log files generated by the execution of SSIS packages .

Analysis of the log file may take up large quantities of time,
ie. to find an error that occurred during the execution of the packages we use search function in notepad to traverse through the log file generated by the package execution. 

This tool will help ease up the process by providing a parsed HTML file which is readable version of the log file, highlighting and grouping the errors and warnings thus making it easy to find the error quicker. 

Read on to find out more

1. Launch SSIS PILL .exe

2. Click on Get Files after 

  •     Selecting your folder that contains the SSIS log files
  •     Click on Get Files - on the left side all files in the selected directory will be displayed
  •     This will show the status of the file like success or failure and time taken
  •     This is a pictorial indication that the file is a success
  •     These are where warnings are displayed

3. On selection of file with error records

  •     Now the picture is different for log files with ERRORS.
  •     The first grid shows the ERRORS and the second the WARNINGS
  •     This thing works full screen too

4. Click on Open In HTML for Parsed Log File, the parsed file will open in browser.
As you can see this is in  a better readable format.

  • Has status of execution at the top
  • First grid is of ERRORS
  • Second Grid is of WARNINGS

5. Other buttons

Export to HTML will Create a directory in the same as your parent directory of your log folder and place the Parsed HTML files there.

Open in HTML will open the selected log file's parsed format like in step 4 in the browser

Open in Text - will open normally in a text editor

6. Mail
Export - Mail will add the attachment of the parsed log file and open up outlook ready to send.

(you can configure default path for the log folder and the email id to which mail needs to be sent in the config file )

If the above setup file doesnt work then use the one below, extract from the zip folder and run the SSISLogSimplifier.exe file

Monday, September 1, 2014

Rooting and flashing Sony Xperia J ST26i

Writing this post after successfully flashing Sony Xperia J ST26i with DARK MOON AVD ROM

I followed the instructions given in


Take a backup of your contacts, sd card etc. I used My phone Explorer

Update the phone's firmware
Go to Settings > About phone > Software updates > System updates
or use SONY PC Companion


Unlock BootLoader
Followed the steps given here

How to Unlock Bootloader of Sony Xperia Devices (official and universal tutorial)
  1. Go here and check whether your smartphone is on the “unlock bootloader” list or not. If your phone is not listed there it means that you cannot use this guide for unlocking the system.
  2. Also, on your handset type and dial: *#*#7378423#*#*; then go to “Service info -> Configuration -> Rooting Status” and check if the “Bootloader unlock allowed” says yes. If the “no” answer will be displayed then you will not be able to unlock the bootloader of your device.
  3. Now, extract the file named “downloadinf.zip” (which has been downloaded before) on your computer.
  4. Then, copy the obtained file (“android_winusb.inf”) to path c:\android-sdk\extras\google\usb_driver.
  5. Click yes if asked to overwrite something.
  6. Type *#06# on your phone and get the IMEI number; write it down as you will need it a little bit later.
  7. Now, go here.
  8. On the first page click on “Yes, I’m sure”.
  9. Agree to Sony’s legal terms and then hit “I accept”.
  10. On the next page enter your name, email and your device’s IMEI number and click on “Submit”.
  11. An unlock code will now be offered; note it down.
  12. Turn off your device and connect the same with the computer by pressing on the Menu button (for the Xperia arc, Xperia arc S, Xperia neo, Xperia neo V, Xperia pro handsets), or on the Search button (for the Xperia Play device) or on the Volume Up button (for the Xperia mini, Xperia mini pro, Xperia ray, Xperia active, Live with Walkman, Xperia S smartphones).
  13. Install the drivers on the path mentioned above (c:\android-sdk\extras\google\usb_driver).
  14. Now, on your computer open command prompt: “start -> run -> type cmd”.
  15. On the cmd window enter the following commands (one at a time): cd C:\android-sdk\platform-tools; fastboot.exe -i 0x0fce getvar version; fastboot.exe -i 0x0fce oem unlock 0xKEY (replace key with the code obtained before).
  16. That’s all, now the bootloader will be unlocked.
  17. In the end, remove the USB cable and reboot your smartphone.

Problem Faced: STEP 13  The driver to be installed was not accepted by the system.
Hold down the Windows key on your keyboard and press the letter C to open the Charm menu, then click the gear icon (Settings).

Click More PC Settings.

Click General.

Under Advanced Startup, click Restart Now.

NOTE: In Windows 8.1, the ‘Restart Now’ button has moved to ‘PC Setting -> Update & Recovery -> Recovery.’

After restarting, click Troubleshoot.

Click Advanced Options.

Click Windows Startup Settings.

Click Restart.

After restarting your computer a second time, choose Disable driver signature enforcement from the list by typing the number 7 on your keyboard.

Your computer will restart automatically.

After restarting, you will be able to install the  drivers normally; however, Windows will display a warning message. When the warning appears, click Install this driver software anyway

Soln from:  https://learn.sparkfun.com/tutorials/disabling-driver-signature-on-windows-8/disabling-signed-driver-enforcement-on-windows-8

So after unlocking your bootLoader.


Download from here
AVD Rom Latest Release

Addon Archive

Kernel ftf


place Rom & Addon zip on externel sdcard

Place the downloaded file ClockworkMod- into the folder  C:\android-sdk\platform-tools

  • Download ClockworkMod from the link above
  • Switch off phone
  • Hold Vol-UP button
  • Insert USB cable, wait for blue light
On the cmd window enter the following commands (one at a time): cd C:\android-sdk\platform-tools
run fastboot flash boot ClockworkMod-

and then type
run fastboot reboot

  • when the purple LED shines, press and hold the Vol-UP button
You are now in ClockworkMod Recovery!

Wipe data/factory reset, wipe cache partiton, go to advanced wipe dalvik cache. then go to mounts & storage format system.

Go to install zip from sdcard choose zip from externel sdcard. flash rom

when installation is finished go back to advanced choose fix permissions


Now we need to download and install flashtool 
After installing it. 

The Kernel ftf  that you downloaded
"st26i_11.2.A.0.31 Kernel By Gavster26@XDA_Central Europe.ftf" needs to be extracted. 
You need to have 7Zip or any other file extracting programs.
Once you are done extracting you will find a file called kernel.sin 

follow the instructions in the video
Note: u need to browse for the kernel.sin file that you extracted.

Note:Be careful while browsing and selecting the right file, I happened to choose the wrong one and my phone would not startUp but I retried with the right file and it worked.
Now Flashing of new kernel is done.


Next for Addon Package: It is the same as the instructions in part 3. 
Except that here we select the addon package zip from sd card 
After that follow PART 4 (Flash the kernel again)

The file you downloaded FIXES_FOR_AVD_1.6_V.zip extract it and place the files on sd card.

Download Root Browser place it on ur phone SD card.

Start your phone and install the RootBrowser APK that you downloaded.

Now open it up and copy systemui.apk from the extracted files of FIXES_FOR_AVD_1.6_V.zip to /system/app give permissions rw-r-r
Note: there will already be a copy of systemui.apk rename it to sytemui_copy.apk and then push/copy the file. Tap and hold on the file for long and select permissions from the menu and give it as rw-r-r

Similarly copy  framework.jar to system/framework give permissions rw-r-r
Note: there will already be a copy of framework.jar rename it to framework.jar_copy.apk and then push/copy the file. Tap and hold on the file for long and select permissions from the menu and give it as rw-r-r

You are done.
Be careful while flashing/rooting/unlocking as the methods vary from each model.
Refer XDA forums when in doubt.

Sunday, August 31, 2014

Top 5 reasons to root your Android device

1. Increase Internal memory
2. Fix any broken button
3. Better ROMS
4. Better Looks
5. Performance

If you have an Android phone and in need of any of the above for your phone. Then you need to root your android phone.

Rooting is a means of unlocking the device's capability allowing the user to have complete control.
Rooting method is different for different phone. Lookit up well before you proceed.
For more info: www.xda-developers.com/

Tuesday, May 27, 2014

Remove HulaToo adware manually

HulaToo is an Adware that puts ads on ur browsers and slows down ur system. It comes with unwanted downloads.

HulaToo Ads
Anyways if you begin to see HulaToo ads on ur browsers its safe to remove them.

1. Go to Control Panel and select Install/Uninstall Software and select HulaToo and Unistall it.

2. Reset ur Browsers.

3. Go to Win+R type regedit and hit ctrl + F and search for HulaToo and delete all the entries that contains this. Repeat this search and delete till there are no such entries

If the above steps does'nt work then do the following
1. Go to Win+R (run window) type services.msc

2. All the services running in your system opens up. Search for updateHulaToo.exe and utilHulaToo.exe and just to make sure look out for any name containing HulaToo in the window.

3. Now double Click on one process like updateHulaToo.exe select startUp type in the window as Disabled repeat the same for the other process i.e. utilHulaToo.exe and other services with the HulaToo in it.

4. Restart System

5. Go to MyComputer-> C Drive > ProgramFiles (x86) or ProgramFIles and delete HulaToo Folder. Later Reset ur Browsers.
6. Go to Win+R type regedit and hit ctrl + F and search for HulaToo and delete all the entries that contains this. Repeat this search and delete till there are no such entries

If u have any doubts or need assistance do as in the comment section

Sunday, April 20, 2014

Getting over the Heartbleed

Not the love life, the life Online

The simple explanation:
Heartbleed allows a hacker/attacker to have access to a random chunk of memory on the server that contains ur encryption keys or un-encrypted passwords, site data etc while the hacker remains anonymous. You would not know if it hit you.

What can the end user do???
Check if your provider/website of which you are a member of has patched the heartbleed bug. 
Here's the list of websites which have been affected by the heartbleed bug.
 Just change the Password.

 Android users update ur phones.

In detail:
Transport Layer Security (TLS) and its predecessor, Secure Sockets Layer (SSL), are cryptographic protocols which are designed to provide communication security over the Internet. 
One library that implements TLS is OpenSSL.

66% of the websites use OpenSSL, so knowingly or unknowingly u have been bugged.

A few versions earlier to the current OpenSSL, the negotiation between the client and server before sending expensive data was expensive. Most of the time the packets used to get lost or corrupt due to too many requests and need to drop its end of the TLS connection.
So the guys at the OpenSSL formulated a solution. i.e A way of telling that the server is available or its currently overwhelmed by different requests.  This way of telling if the server was available was done with the help of "KEEP ALIVE" messages known as "HEARTBEATS".

How does the HEARTBEAT work?
ex: suppose you send an request as a payload "you there man" the size is 13 so the webserver to whom you requested stores the payload as well as the size 13 into its memory. So when you send the "keep-alive" request the message is sent back to the client this is done by reading the message out from the memory of the server where it was stored following 13 places(size of ur payload).So, ur connection is kept alive.

The FLAW: Heartbleed
OpenSSL library never checked that the Heartbeat payload size corresponds with the actual length of the payload being sent.  A user is allowed to input any number up to 65535 (64 kilobytes) regardless of the true size of the payload. 
So now the attacker will send an heartbeat request for 64kb even though his payload size is 13 bytes. The server will start responding to the heartbeat request by sending the first 13 bytes and  continuing upto 64kb from the server memory to the client. The data received by the client will contain encryption keys, usernames, unencrypted passwords, user information, site information etc etc . In short whatever is put onto the server memory which is relatively everything.
All this can be performed anonymously and in a repeated manner so accessing different parts of the server memory. 

Affected users should upgrade to OpenSSL 1.0.1g. Users unable to immediately
upgrade can alternatively recompile OpenSSL with -DOPENSSL_NO_HEARTBEATS.

1.0.2 will be fixed in 1.0.2-beta2.
--Official Statement
Check if your site is affected by using this tool by LastPASS

You need to revoke your current secret TLS keys and regenerate new ones. Coz there is no telling if you have been hit and run coz all these attacks are anonymous. 

Android users of V.4.1.1 Jellybean, need to update their phones. (Better to update all android devices irrespective of the version) Download Lookout’s Heartbleed Detector or Bluebox’s Heartbleed Scanner apps, both of which will tell you if your Android device is affected by the bug.

Change ur passwords of websites that are affected(atleast by a letter) 

Even VPN's are suffering from Heartbleed. You will have to regenerate the client certificates. http://www.pcworld.com/article/2144962/vpn-provider-proves-openvpn-private-keys-at-risk-from-heartbleed-bug.html

Don't stop there, coz even if you have patched it from the patch received from the vendor there still might be a lot of ways to steal the information. Everyone's checking and trying to find out more vulnerabilities (so should you) and a few have found too like the Reverse HeartBleed

Reverse Heartbleed
The Heartbleed bug (CVE-2014-0160)can be used to attack clients as well as servers. Many organizations have hosts which initiate outbound SSL connections (pulling updates, fetching images, or pinging webhook URLs). These hosts are often on a separate infrastructure (with different SSL dependencies) within the organization firewall. These hosts may be vulnerable to the reverse Heartbleed attack. 
This is the tool to check for it. https://reverseheartbleed.com/

Reverse Heartbleed is more tricky for the attacker however once you have patched the heartbleed the reverse heartbleed becomes more trickier.

This bug has been around for 2 years
There are claims that no hackers knew about this and it was the researchers who found about it probably the NSA and Google(since a month) knew it. 
The race is on to find the next bug. It's got a reward too. http://www.theregister.co.uk/2014/04/16/open_ssl_crowdfunding/

Microsoft determined that Microsoft Account, Microsoft Azure, Office 365, Yammer and Skype, along with most Microsoft Services, are not impacted by the OpenSSL “Heartbleed” vulnerability. Windows’ implementation of SSL/TLS is also not impacted. A few Services continue to be reviewed and updated with further protections. 


Thursday, February 27, 2014

EMPLOYER E-SEWA PF India Annexure ii upload tool

This is an unofficial tool to help ease the process of uploading Annexure ii to the e-sewa portal.
The official instructions i.e the format for upload is specified here http://www.epfindia.com/ECR/AnnexureII_ErrorCodesList_10042013.pdf

Its a lot complicated for non tech people. So to simplify things I have created an excel sheet where you need to enter the employee details and then just click on a button which will generate the file to be uploaded in the specified format by EPF India.

You should be able to do it in 5 simple steps,  let me take you step by step

Step 1: Download the excel sheet Click Here

Step 2:
These are the columns you ll need to enter into the excel sheet

Open the excel sheet you will find the same columns 

So start filling your employees details, I shall fill the employee Anil Singh on my sheet

Step 3: 
Click on the generate file button.
Step 4:
Enter the path for the file to be stored along with the filename with the extension .txt
ex: d:\FileToBeUploaded.txt and click on Ok

Step 5:
Go to the destination folder/ drive whatever you gave in the above step and open it

Check if all the records are there and then just upload it in the portal.

Important: Every time you plan on using this sheet, use a fresh one, don't use previously entered sheets.
                Before uploading the text file you need to make sure there are no extra lines in the file.

If any doubts or clarifications mention them in the comments, I shall respond. If any errors in upload, epf provides the error codes etc,  post them too in the comments.

Later I shall cover the code of the Macro.

Tuesday, May 28, 2013

Getting over a heartbreak/breakup

According to Greek mythology humans were originally created with 4 arms 4 egs & a head with 2 faces.

According to Greek mythology humans were originally created with 4 arms 4 legs & a head with 2 faces.

If the above pic is true m so screwed...

Well I'm writing a few ways to get over your ex Wife/Gf/Bf/Husband. They dint seem to workout for me but they did help a lot of my friends, so I decided to put it up here.

When you breakup the feeling of betrayal, misplaced guilt, depression etc etc combine and grind your thoughts. To get over it is not easy but possible
Here are a few things u need to know
* If they left you for no apparent reason then say to yourself that they are happy without you. It was not meant to be.

* If you truly loved someone, then it means that their happiness is the only thing that matters to you. So just pray that they'll be happy no matter what.
It is hard to accept that he/she is happy without you, but hey they are HAPPY

* Letting go can be the hardest thing to do, because of all the memories created when together , So, create new ones alone/ with someone. Try not to compare with what was / what will be. Things are never gonna be the same but only better.

*Mornings can be the hardest, such as waking up alone/ waking up with no text from him / her (such as gm/ good morning). Just say to yourself I'm not going down that  road today and get off your bed asap.
It takes time to get rid of memories/routines you've had in your relationship.(Avg 12 months). Don't worry one day u shall just stop thinking about that person.

* Don't drive yourself to suicidal thoughts they tend to come up very often. Try and be calm, pray / do whatever works for you. Just remember by doing something stupid you are not causing any good but just making things harder for the ones who really care about you. Talk to someone who you can trust. If you cant find anyone talk to yourself, never think that you are alone. Think about how small you are in the Universe, in your mind zoom out from your place ur state ur country the world the earth the solarsystem the milkyway the cluster of galaxies and so on and on, so how big is your problem now???.Think about all the less fortunate people, people who have to worry for their 3 square meals. Tell yourself that you can handle this and will emerge stronger than before. It is true and it will happen.

*"I may live a hundred lifetimes without you but not one without thinking about you"~ Anonymous
Well the above statement sums it all. We tend to keep thinking about them all the time, all the memories, all the promises, all the dreams built together etc etc . It is not going to help us in anyway. It just increases the pain. So keep those thoughts at bay. If they get out of control/end up in tears, say to yourself that what you had for that person was pure and full of life and you did your best to keep it together but may be they dint want it to be that way, they thought that they would lead a better life without you, so Life goes on and apparently his/her life goes on without you. (That's the hard truth, the sooner you accept the better it is for you)

Here are a few things u need to follow
* Stop listening to songs that you both used to listen(couple songs). I am not saying stop completely listening to it but give it a break.
* Try and avoid contact at any event, such as mutual friend's party/event
* Distract yourself, focus your attention on your friends.
* Explore your friendzoned friends, one of they may really care about you. (Don't jump immediately into a new relationship, take it slow )
* Stop stalking their Facebook profile, if you cant control block their profile. If you still cant control delete your profile for some time.
* Try and get rid of all the gifts you exchanged.
* Try also to get rid of the things that remind you of that person.
* Try to avoid places that you used to hangout with that person for some period.

So all de best. Remember just BE YOURSELF and that you are NEVER ALONE


Blog Widget by LinkWithin