In this article, we will explain how to generate SSIS packages using business intelligence markup language by providing a step-by-step guide where we will illustrate how to configure each object and how to use variables, expressions and parameters within the package.
SSIS: Execute T-SQL Statement Task vs Execute SQL Task
SQL Shack
How to get GraphLayout XML from programmatically generated SSIS package?
Stack Overflow
Getting started with Biml
SQL Shack
Manipulating SSAS OLAP cubes using SSIS
SQL Shack
SQL Server functions for converting a String to a Date
SQL Shack
A SQL join on multiple tables: overview and implementation
SQL Shack
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
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
Linking relational databases with OLAP cubes
SQL Shack
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]