Building Custom Tasks for SQL Server Integration Services

SQL Server Integration Services (SSIS) is widely used whenever data from outside sources is loaded into a SQL Server database. Extract, Transform, and Load (ETL) processes feeding data marts and business intelligence systems are two common scenarios in which SSIS is used, and it's often the case that SSIS's built-in feature set can be enhanced to make loads run faster, and to otherwise process dat...