This tutorial explains how lookups may highly decrease SSIS package performance and when they should only be used in Business Intelligence projects.
SSIS Bad Habits: Slow lookup transformations
MSSQLTips.com
SSIS Bad Habits: Wrong OLE DB components configuration
MSSQLTips.com
This tutorial will explain some of the mistakes that SSIS developers usually make when configuring the OLE DB component while designing SSIS packages and how they should avoid them.
SSIS Bad Habits: Inefficient Data Staging Strategies
MSSQLTips.com
This article explains data staging and staging methods in SSIS, and how to choose the appropriate approach while designing your data pipeline.
SSIS Bad Habits: Using Sort and Merge Join Components
MSSQLTips.com
This tutorial explains the main cause of the performance problem faced while merging different data sources in SQL Server Integration Services and provides a few alternatives.
SSIS Extension for Visual Studio 2022
Stack Overflow
Is SSIS extension available for Visual Studio 2022?
An overview of DIFFERENCE and SOUNDEX SQL functions
SQL Shack
This article gives an overview of DIFFERENCE and SOUNDEX SQL Server built-in system functions. It explains how to use those functions and how do they work.
Import flat files into seperate SQL Server Tables using SSIS
Stack Overflow
This answer explains how to to loop over multiple flat files and insert them into seperate SQL Server tables.
Professional Certification Exams provided at NO COST
GitHub
Since many students and developers cannot pay for the certifications exams fees, I created a #GitHub repository to list all free professional exams provided by tech companies even if it was offered on a specific occasion (ex: Microsoft Ignite Cloud Skills Challenge). I will be grateful for any contribution. And...
[Read More]
Getting started with SQL Server CLR functions
SQL Shack
This article will explain how to create a SQL Server CLR function stored in a C# class library without creating a SQL Server database project. We will first briefly explain the concept of .NET common language runtime (CLR) and then build a C# class library using the .NET framework. Then,...
[Read More]
Why is the SSIS variable not passing the milliseconds part into the query?
Stack Overflow
This answer explains why the milliseconds part is removed when passing a DateTime value as a parameter in a OLE DB source SQL Command. Besides, it explains the different data types systems used in SSIS.