Uploading On-Premise data to Azure Blob Storage using SSIS

Azure SSIS Feature pack can be used to upload the data over to Azure Storage account. In this article, Supriya Pande will describe how you can upload the data to Azure Blob Storage using SSIS task.

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.