Knowledge.ToString()

Tag: excel

  • 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…

    |

  • How to Replace VBA Code from Excel/Word

    Have you ever had a situation where you wanted to replace the existing VBA code from Excel/Word and did not want to open up each file and change it? Well, remember that Excel and Word files are nothing but a zip file. You can easily create a program to replace the file from “zip” file.…

    |