Monthly Archives: April 2016

The Value Violated the Integrity Constraints for the Column

SSIS Package Error You are using SSIS package to load data into SQL table and suddenly you get the error “The value violated the integrity constraints for the column”. It does not give enough information of why the error occurred. Root Cause for Error SQL Server has following integrity constraints Primary Key Foreign Key Not […]


Restore Missing Button and Drop Down Controls in Excel

Have you ever faced a situation where suddenly all the buttons, drop downs and various controls are missing from your Excel spreadsheet? Well, it’s not gone but it is hidden. Here is the setting to make the controls visible. Go to File > Options > Advanced > Display options for this workbook > For objects, […]


How to Use Plain Old JavaScript File into Node.js as a Module

If you want to use your plain old JavaScript file into Node.js, you need to create a module which is nothing but a fancy wrapper around your JavaScript file and then you can use all the functions of your JavaScript object into Node.js. Environment Windows 7 (64 bit) Node.js 4.4.2 (64 bit) Path already contains […]