In this article, we will give a brief overview of SSIS Balanced Data Distributor (BDD). In addition, we will give some examples and illustrate alternatives.
SSIS Balanced Data Distributor Overview
SQL Shack
An overview of the Data Profiling task in SSIS
SQL Shack
The Data Profiling task in SSIS is an important task that can be used to assess the quality of data sources. Unfortunately, this component is not widely used by many business intelligence developers.
[Read More]
SQL OFFSET FETCH Feature: Loading Large Volumes of Data Using Limited Resources with SSIS
SQL Shack
In this article, we illustrate how to use the OFFSET FETCH feature as a solution for loading large volumes of data from a relational database using a machine with limited memory and preventing an out of memory exception. We describe how to load data in batches to avoid placing a...
[Read More]
SSIS Script Component Overview
SQL Shack
SSIS Script component is a prominent strength of SQL Server Integration Services since it allows developers to implement any complex logic and utilize libraries from the powerful .NET framework or third-parties. In this article, we will give an overview of SSIS Script component, and illustrate the benefits of using it....
[Read More]
SSIS Flat Files vs Raw Files
SQL Shack
In this article, we will give an overview of using Flat Files and Raw Files in SSIS, then we will illustrate some of the differences between using these two types.
SSIS XML Destination
SQL Shack
Until now, Microsoft has not included the XML Destination component in SQL Server Integration Services (SSIS). Many years ago, this component was requested on the Microsoft connect website, but it was closed as “Won’t fix.” For this reason, many workarounds and third-party components were created. In this article, we’ll talk...
[Read More]
SSIS Data types: Change from the Advanced Editor vs Data Conversion Transformations
SQL Shack
In this article, I will first give an overview of SSIS data types and data types conversion methods and then I will illustrate the difference between changing the columns data types from the Source Advanced editor and using Data Conversion Transformation.
SSIS Connection Managers: OLE DB vs ODBC vs ADO.NET
SQL Shack
In this article, I will first give an overview of the OLE DB, ODBC, and ADO.NET SSIS connection managers. Then I will try to illustrate the difference between them when trying to connect to SQL Server.
SSIS Derived Columns with Multiple Expressions vs Multiple Transformations
SQL Shack
In this article, we will first give an overview on SSIS derived column transformation, then we will run an experiment to check if there is any difference between adding multiple expressions within one derived column transformation and adding a derived column transformation for each expression.
Execute SQL Task in SSIS: Output Parameters vs Result Sets
SQL Shack
In this article, I will describe the difference between using output parameters and result sets within Execute SQL Task in SSIS.