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?
Getting started with Biml
Manipulating SSAS OLAP cubes using SSIS
SQL Server functions for converting a String to a Date
A SQL join on multiple tables: overview and implementation
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 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
Linking relational databases with OLAP cubes
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]