Below is a list of articles that focus on setting up a process using our SSIS tasks, anything you can do in SSIS you can also do through our stored procedures. So if you find SSIS too limiting because you can't set variables, we'd still suggest setting up your initial process in SSIS then see the last article below to read about taking the SSIS process and converting it to stored procedures.
Installation:
- Installing mSQL (With Screenshots)
- Adding the SSIS Components to the Toolbox (SQL 2005 and 2008 only)
- Explanation of the SSIS Tasks
Address Validation (for those with the module):
- mSQL - SSIS Tutorial - Setting up US Address Validation
- mSQL - SSIS Tutorial - Addressing - understanding the outputs
- mSQL - SSIS Tutorial - Addressing - understanding the result table
Basics:
- mSQL - SSIS Tutorial - Setting up Generate Keys - Setting a template
- mSQL - SSIS Tutorial - Setting up Key Generation
- mSQL - SSIS Tutorial - setting up a basic matching process
- mSQL - SSIS Tutorial - incorporating exact matching
- mSQL - SSIS Tutorial - Understanding Output Tables From A Matching Process
- mSQL - SSIS Tutorial - findoverlap vs findmatches
- mSQL - SSIS Tutorial - setting up a findoverlap
- mSQL - SSIS Tutorial - Incorporating Exact Overlap
- mSQL - SSIS Tutorial - mSQL Overlap Output Tables
- mSQL - SSIS Tutorial - Find Matches/findoverlap more in depth, weights and constraints
Advanced
- mSQL - SSIS Tutorial - Understanding Matching - Why did this score 85 on Individual Level?
- mSQL - SSIS Tutorial - Understanding Matching - Why did this score 85 on Business Level
- mSQL - SSIS Tutorial - Tight Business Matching
- mSQL - SSIS Tutorial - What are all these key fields?
- mSQL - SSIS Tutorial - Ouptut Tables, Filtering and Quality Scoring
- mSQL - SSIS Tutorial - moving a matching process from SSIS to Stored Procedures