Advanced SSIS Fuzzy Matching via Record Linkage Methodology
Greatly improve SSIS Fuzzy Grouping performance by using a Conditional Split and Multi Cast.
2012-07-05
7,698 reads
Greatly improve SSIS Fuzzy Grouping performance by using a Conditional Split and Multi Cast.
2012-07-05
7,698 reads
The article will provide an overview of Master Data Services and a sample SSIS Package.
2010-03-02
10,001 reads
Tutorial on using Script Component, Regular Expression and derived Column Transform to dynamically map different source column types into the appropriate target column for address data.
2010-02-23
3,233 reads
Roll Your Own Fuzzy Match / Grouping (Jaro Winkler) - T-SQL
2009-06-10
39,872 reads
This article will review the processes for providing Operational Analytics via Microsoft Analysis Services, Informatica and Qlikview
2009-06-03
1,925 reads
This article demonstrates Data Profiling Functional Dependency
2009-05-20
4,358 reads
Roll Your Own SSIS Fuzzy Matching / Grouping (Jaro - Winkler)
2009-03-04
10,997 reads
We bring you part 2 of a series on SSIS programming from Ira Whiteside and Actuality Business Intelligence. This article shows you how to dynamically build a package using code.
2008-10-10
18,311 reads
In part one of this series from Actuality Business Intelligence, Ira Whiteside brings us a look at building your own SSIS transformation.
2008-07-30
17,084 reads
A new series sponsored by Actuality Business Intelligence on data warehousing. In part 1, the data flow in SSIS packages are used to profile the source data and determine how it should be handled in the process.
2008-07-23
9,756 reads
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
In a previous blog post we went through how to build a Docker container...
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
I'm only processing 50,000 records not everything from the Table where there are 250,00...
Comments posted to this topic are about the item The Marked Transaction
Comments posted to this topic are about the item What happens when we drop...
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers