Enhancing SSIS ETL Tools with SolarWinds Task Factory

SQL Server Integration Services (SSIS) has been the de facto ETL tool for over 15 years for DBAs, Developers and Business Intelligence Professionals to extract, transform and load data (i.e. ETL tasks) for specific business processes, data-centric applications, data warehousing, reporting and data exchange between organizations. SSIS is a great product with high adoption across the globe, but has some limitations related to modern data sources, performance and streamlining tedious tasks. How can we overcome these limitations and have SSIS provide greater value?

The Art of Data Ingestion - Part 1

Data movement is a fundamental piece of a data engineer’s duties, and recently I’ve been thinking about the art of data movement. What are some of the most important pieces that a data engineer needs to think about when confronted with data ingestion? There is of course data exporting as well, and in that case, […]

SSIS Environment Design Patterns

In this article, we will see 3 SSIS design patterns that we can use to set up SSIS configurations and deployments.

A brief history of SSIS evolution

Learn about the history and different versions of Integration Services (SSIS) in SQL Server.

SSIS Catalog Object Names

SSIS Catalog Objects

Running SSIS in ADF

Execute SSIS Package with SQLCMD and Parameters

In this article we walk through the steps of how to run an SSIS package using SQLCMD along with passing parameters to the SSIS package.

How to Execute SSIS Packages from SQL Server Agent

Learn about best practices for developing SSIS packages that you want to execute from SQL Server Agent and the steps to follow.

Getting Informative SQL Agent Notifications from Failed SSIS Packages

Getting informative error messages when something goes wrong with an SSIS package is critical, especially if you are not in front of your computer.