How to Create Your First SSIS Package

A SQL Server Integration Services (SSIS) package includes the necessary components, such as the connection manager, tasks, control flow, data flow, parameters, event handlers, and variables, to execute a specific ETL task. For an introduction to key SSIS functionality, check out the SSIS Basics guide.

To demonstrate how to get started with SQL Server Integration Services (SSIS), we’re going to walk through the steps to create and test a simple SSIS package. In this example, we’ll create a package that truncates a staging table and loads that same table with the data found in a flat file.