This presentation shows the basics of SSIS to help with automating database tasks, such as maintenance, importing and exporting data, or ETL transactions. The discussion will start with an understanding of when SSIS should be used vs. when a database object, such as a view or stored procedure, should be used. You will learn about the concepts of syncronous vs asyncronous and non-, semi- and full- blocking transformations. You will also see how to create a basic package, and how to use the built-in logging and configurations. Lastly, we will talk about the importance of organizing the overall SSIS structure. This presentation gives you a great start on how to use SSIS, gives you something to think about and provides resources for where to continue learning or researching.
You can get to the presentation slide-deck by clicking here. There are helpful notes on most of the slides.
This session is also available via a recording, which can be found by clicking here. It was presented to the Virtual DBA Fundamentals PASS chapter. ** Note: Please right click and choose save as, then watch it from your local PC.