Category Archives: SSIS

SSIS ETL Framework

  In my current job, we have a custom ETL framework to control the execution of SSIS packages. Some of the features of our ETL framework is as follows: a) Control the execution of packages using metadata tables We use … Continue reading

Posted in BusinessIntelligence, DataWareHousing, SSIS | Leave a comment

ForEach Loop Container – Continue On Error

Download Sample Package and SQL Files[Extract the zip file – SSISContinueOnError.zip containing SQL Files to C:\EasyBI such that all SQL files reside directly within C:\EasyBI\SSISContinueOnError] Lets say we use For Each Loop Container for looping around a set of files … Continue reading

Posted in SSIS | Leave a comment