Find Data Differences Between Tables with SSIS
In this article we look at an approach to compare two different sets of data that should be the same to determine where there are potential mismatches of data.
Aleksejs Kozmins is a professional in the Data Warehousing and Business Intelligence area. He has been working in this direction for 15+ years. His main interests lay in development of data integration processes based on SQL Server Integration Services enriched with Visual Studio.NET and efficient usage of T-SQL applied to large data sets. Focused mainly on rational building of ETL, including ETL configuration, detailed logging, productive staging, easy control functions, etc. The achieved results have been successfully introduced in various European scale IT projects. Further, Aleksejs has published his papers on Data Integration topics in the proceedings of International Workshops.
- MSSQLTips Awards: Rookie of the Year Contender - 2019
SSIS Data Flow Parallel Processing
In this tip we look at an SSIS package that allows for automating swapping of destinations based on external controls.
SSIS Data Flow Task with Pause Functionality
In this tip we look at a way to control and delay ETL tasks within an SSIS package based on some external process.
How to Stop a SSIS Package Execution from Code
In this tip we look at a way to stop the execution of a SSIS data flow task that is running by executing an outside process to stop the data flow immediately.
Parallel Execution of Tasks in SSIS
In this tip we look at a process to load data in parallel using an SSIS package that loads data in an optimized way.