SSIS Merge Join vs. Merge Transformation

SQL Shack

SSIS Merge Join and Merge transformations are two similar components used to combine two input data sources into one output. This article explains both transformations and illustrates when and how to use each one of them.
Tags: ssis

Popular free SQL online compilers

SQL Shack

This article will mention some of the most popular free SQL online compilers that help developers debug and test their SQL code without installing an SQL instance locally or buying one on the cloud.
Tags: sql tsql

An overview of the VS_NEEDSNEWMETADATA SSIS exception

SQL Shack

In this article, we will briefly explain the VS_NEEDSNEWMETADATA SSIS exception, one of the most popular exceptions that an ETL developer may face while using SSIS. Then, we will run an experiment that reproduces this error. Then, we will show how we can fix it.
Tags: ssis