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.

SQL Server 2016 SSIS Basics - Install SQL Server Data Tools

Step-by-step instructions for downloading and installing SQL Server Data Tools (SSDT) for SQL Server 2016.