An overview of the DTExec utility in SSIS

SQL Shack

DTExec is a tool used to configure and execute SQL Server Integration Services (SSIS) packages. Many developers and database administrators use this tool, especially when automating the package execution using third-party applications or non-supported programming languages. This article will introduce this tool to you, also help you understand how and... [Read More]
Tags: dtexec ssis

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

Manipulating SSAS OLAP cubes using SSIS

SQL Shack

In this article, we will give an overview of the first two tasks provided by Integration Services (SSIS) that allows manipulating OLAP cubes and executing commands over SSAS. These two tasks are Analysis Services Processing Task and Analysis Services Execute DDL Task.
Tags: ssis ssas olap