Integration Services (SSIS) for the DBA

You are a DBA and your manager asked you to manage the Enterprise Data Warehouse, which includes a number of ETL packages. While comfortable with the relational database, you are not sure how to handle Integration Services (SSIS).

In this session, you will learn what SSIS is and what components it consists of. You will also learn how to use the SSIS catalog, which is new in SQL Server 2012, to track the execution of the package. As well as how to troubleshoot packages when they fail or cause problems.
  • Downloads
    Video available MP4 Video HD 542 MB
  • SpeakerBIO
    David Peter Hansen is a Microsoft Certified Master (MCM) and has over a decade of experience with database development and administration on SQL Server and the Microsoft Business Intelligence platform. Today, he works as Senior Premier Field Engineer at Microsoft. He specializes in delivering training as well as scalable architecture and performance tuning on large-scale data platform solutions. He is a frequent speaker at conferences, and have given talks in Europe, USA, and South Africa.
  • Video