Category: SSIS

Script to create copies of the existing object

Many a time we need copies of an object but with different names. I also got a requirement to process the files in parallel using SSIS. We had already implemented the parallelism, but at the entity level. For example, if there are 5 entities such as Customer, Product, Order, Transaction, Balance etc. then we had … Continue reading Script to create copies of the existing object →

SSIS Logging – Linking sysssislog with custom log

I was working on an ETL solution, which was expected to run for hours. It has become extremely important to track the errors properly, so as to debug the error quickly. During the initial phase, we had to struggle with the errors. I googled a lot to find a solution that can lead me directly … Continue reading SSIS Logging – Linking sysssislog with custom log →