SSIS: Execute T-SQL Statement Task vs Execute SQL Task
SQL Shack
Posted on March 4, 2020
In this article, we will give an overview of the Execute T-SQL Statement Task, and we will make a small comparison with the Execute SQL Task which is more popular.
How to get GraphLayout XML from programmatically generated SSIS package?
Stack Overflow
Posted on March 2, 2020
What is the SSIS package GraphLayout? Is it readable in programmatically generated SSIS package?
Getting started with Biml
SQL Shack
Posted on February 26, 2020
In this article, we will give a brief overview of BIML by showing how it can be installed and how we can use it to generate SSIS packages using the BimlExpress tool. Finally, we will provide some good resources to learn this technology.
Manipulating SSAS OLAP cubes using SSIS
SQL Shack
Posted on February 12, 2020
In this article, we will give an overview of the first two tasks provided by Integration Services (SSIS) that allows manipulating OLAP cubes and executing commands over SSAS. These two tasks are Analysis Services Processing Task and Analysis Services Execute DDL Task.
SQL Server functions for converting a String to a Date
SQL Shack
Posted on February 6, 2020
In this article, we will explain how a string to date conversion can be achieved implicitly, or explicitly in SQL Server using built-in functions such as CAST(), TRY_CAST(), CONVERT(), TRY_CONVERT() and TRY_PARSE().
A SQL join on multiple tables: overview and implementation
SQL Shack
Posted on January 28, 2020
SQL join multiple tables is one of the most popular types of statements executed while handling relational databases. As known, there are five types of join operations: Inner, Left, Right, Full and Cross joins. In this article, we will explain the meaning of Joins in SQL, we will describe each...
[Read More]
An overview of the SQL cursor @@FETCH_STATUS function
SQL Shack
Posted on January 23, 2020
SQL cursor is one of the most popular database objects. It is used to retrieve data from the result set of an SQL query one row at a time. Even if the cursor is not recommended from a performance perspective, they are still widely used especially when handling a small...
[Read More]
Yet another bunch of SQL string functions
SQL Shack
Posted on January 13, 2020
This article is a supplement to the previously published article, An overview of SQL String Functions . This time, we will describe another bunch of SQL string functions used in SQL Server.
Linking relational databases with OLAP cubes
SQL Shack
Posted on January 10, 2020
One of the most asked questions is how to link an OLAP cube with a relational database, or in another way how to join the result of an MDX query with a table stored in a relational database. In this article, we will illustrate how to link a SQL Server...
[Read More]
SSIS Extract links from Excel cells to load into SQL
Stack Overflow
Posted on January 2, 2020
A step-by-step guide to extract hyperlinks from excel files and store them into SQL Server using SSIS
An overview of SQL String Functions
SQL Shack
Posted on December 25, 2019
In this article, we will try to give a brief overview of the SQL string functions used in SQL Server and we will provide some examples. A string function is a function that takes a string value as an input regardless of the data type of the returned value. In...
[Read More]
ORADIEX: A Big Data driven smart framework for real-time surveillance and analysis of individual exposure to radioactive pollution
BDCSIntell'2019
Posted on December 16, 2019
Radiation pollution has been always a critical concern, since it can cause a huge damage to humans and for nature. To minimize the damage, governments are collecting and monitoring radiation level using advanced systems. In the past years, Big data technologies such as distributed file systems, NoSQL databases and stream...
[Read More]
An overview of the SQL Server Profiler
SQL Shack
Posted on December 9, 2019
In this article, we will describe SQL Server Profiler and how it can be used. In addition, we will mention the tools that are integrated with it- plans about its deprecation, and what are the alternatives?
SSIS Foreach Loop vs For Loop Container
SQL Shack
Posted on December 4, 2019
In this article, first, we will briefly describe foreach loops and for loops. Then, we will give an overview of SSIS Foreach Loop Container and For Loop Container. Finally, we will compare these two containers.
SSIS Balanced Data Distributor Overview
SQL Shack
Posted on November 22, 2019
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.
An overview of the Data Profiling task in SSIS
SQL Shack
Posted on November 21, 2019
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
Posted on November 14, 2019
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
Posted on October 29, 2019
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
Posted on October 29, 2019
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
Posted on October 11, 2019
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
Posted on October 4, 2019
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
Posted on October 4, 2019
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
Posted on September 25, 2019
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
Posted on September 17, 2019
In this article, I will describe the difference between using output parameters and result sets within Execute SQL Task in SSIS.
Execute SQL Task in SSIS: SqlStatementSource Expressions vs Variable Source Types
SQL Shack
Posted on September 9, 2019
In this article, I will give an overview of Execute SQL Task in SSIS and I will try to illustrate some of the differences between writing an expression to evaluate SqlStatementSource property or writing this expression within a variable and change the Execute SQL Task Source Type to variable.
