MicroNugget: How to Create and Configure SSIS Packages

Start your free week with CBT Nuggets. https://cbt.gg/2LZhF9F

In this video, Garth Schulte covers creating and configuring SSIS packages. He further describes what are SSIS projects. He also gets you familiar with the package designer and how to collect the major components of a package, such as tasks, connections, events, parameters and variables.

After watching this video, you will know what SSIS packages are and how you can both create and configure them. Garth shows you how to do this with the SQL Server Data Tools app that comes with SQL Server 2012.

First, he shows you how to create a project within the interface. He then shows you how to configure the package associated with this project through the package designer. There he sets up both the flows and the tasks contained within the package as well as the connections between them.

Finally, he provides an example of creating a task that takes data out of an SQL server database and exports it to a flat file.

Newest training from CBT Nuggets:

🆕 CCNP Enterprise (300-500) | https://courses.cbt.gg/20c

From the CBT Nuggets blog:

• 5 Free Stocking Stuffer Study Resources | https://blog.cbt.gg/xkd
• Introducing our Newest Trainer, Chuck Keith | https://blog.cbt.gg/hnn
• Can You Beat the Most Validated Learner? | https://blog.cbt.gg/l7v
• Trainer Talks: Ben and Garth on Certs, Experience, and Patience | https://blog.cbt.gg/r9h
• Discovering the Best of Server 2016 | https://blog.cbt.gg/7cy

Start learning with CBT Nuggets:

• Microsoft SQL: SSIS | courses.cbt.gg/4sh2
• IT Expert: Getting Started in IT | https://courses.cbt.gg/3o9
• Microsoft PowerShell 4 Foundations | https://courses.cbt.gg/wwb8
• Administering Microsoft SCCM and Cloud Services (70-703) | https://courses.cbt.gg/4fw
• Chef: Setting Up the Chef Environment | courses.cbt.gg/w0uy