The SSISDB Catalog was introduced in SQL Server 2014. With it came a lot of procedures … SSISDB.catalog.create_executionRead more
SSIS
Running an MapForce mapping from SSIS
In an earlier blog post I demonstrated how to map between hierarchical (XML) and relational (SQL) … Running an MapForce mapping from SSISRead more
Sorted data flows in SSIS
Sometimes a data flow in SSIS needs to be sorted. It may be because the business … Sorted data flows in SSISRead more
Add missing lookup in SSIS
Before a fact table is loaded, a common pattern is to do a lookup in SSIS … Add missing lookup in SSISRead more