Scale-Out SQL Server Integration Services Environment: A Sample Pattern

This white paper illustrates how Microsoft SQL Server Integration Services (SSIS) can be used in conjunction with commodity hardware or virtual machines running in Microsoft Azure to build elastic, highly available, and highly scalable ETL solutions.

Azure Data Factory

Dynamic File Column mapping in SSIS.

An efficient and reliable method for reading CSV files with variable columns.

Using SQL Server as a Source with for an Excel Application

I am presenting an MS Excel VBA project which automates the display of SQL Server data tables.

Auto assign Column Data Types for Flat file Source Import

A tip to auto detect data types for flat file sources in SSIS. Never manually enter them ever again!

The DefaultBufferMaxRows and DefaultBufferSize Properties in SSIS

This article shows how DefaultBufferMaxRows and DefaultBufferSize properties can be used to improve dataflow task performance.

Keeping tables online during loading with schema swapping using SSIS

In this article, we discuss how schema swapping method can be used to keep tables online during the load process.

Importing Files in Parallel with SSIS

Run multiple instances of your package in parallel so that each instance processes a portion of the total number of files

Parse Data from a Field Containing Multiple Values using CROSS APPLY

It is possible for a field in a character-delimited text file to contain a list of further-delimited values instead of the customary single value. This article demonstrates how to load such a file into a staging table, then use a CROSS APPLY query to parse the list of values into a related table.

SQL Server Integration Services SSIS 2016 Tutorial

SQL Server Integration Services (SSIS) is the integration and ETL (extract – transform – load) tool in the Microsoft Data Platform stack. SSIS is typically used in data warehousing scenarios, but can also be used in common data integration use cases or just to move data around. SSIS is used behind the scenes in the Maintenance Plans of SQL Server and in the Import/Export wizard.