An overview of the SSIS FTP Task

SQL Shack

In this article, we will explain the File Transfer Protocol (FTP), and we will give an overview of the FTP task in SQL Server Integration Services (SSIS) and FTP connection manager.
Tags: ftp ssis

Using Biml scripts to generate SSIS packages

SQL Shack

In this article, we will explain how to generate SSIS packages using business intelligence markup language by providing a step-by-step guide where we will illustrate how to configure each object and how to use variables, expressions and parameters within the package.
Tags: biml c# ssis

Getting started with Biml

SQL Shack

In this article, we will give a brief overview of BIML by showing how it can be installed and how we can use it to generate SSIS packages using the BimlExpress tool. Finally, we will provide some good resources to learn this technology.
Tags: biml ssis