Configuring and Deploying SSIS Packages
|
Getting data out of one data source and into another is a key challenge for business intelligence. This course will teach you how Integration Services gets configured and deployed in the real world and prepare you for managing workflows with SSIS.
Getting data from a customer or vendor, out of their file, and into your datastore is a key challenge for modern data-driven enterprises. In this course, Configuring and Deploying SSIS Packages, you’ll learn to drive environment-specific SSIS content and get it delivering value. First, you’ll explore the different ways to configure SSIS packages. Next, you’ll discover how to deliver and deploy with a CICD pipeline. Finally, you’ll learn how to monitor and troubleshoot your packages. When you’re finished with this course, you’ll have the skills and knowledge of Integration Services needed to make your package do the business intelligence work of your enterprise.
Author Name: Chris Behrens
Author Description:
Chris B. Behrens is a writer, speaker and software developer, specializing in DevOps. He has been a developer and architect for more than twenty years focusing on small to medium size companies and the development changes they face. He focuses on his flavor of Fear Based Development, whereby a developer ranks their tasks in descending order of anxiety, and how to tackle them in that order. Chief among these anxiety-inducing processes is software deployment, a topic that Behrens focuses upon. He … more
Table of Contents
- Course Overview
1min - Understanding the Basics of SSIS Configuration
27mins - Deploying and Executing SSIS Packages in a CICD Pipeline
23mins - Identifying and Fixing Performance and Logic Issues
18mins - Testing and Verifying an SSIS Package
19mins - Understanding Security in ETL Deployments
23mins - The Future of Integration Services
7mins
User Reviews
Be the first to review “Configuring and Deploying SSIS Packages”
Related Products
Spark and Data Lakes
Learn how to process big data using Apache Spark and manage data lakes.
Organizational Privacy Engineering
Explore organizational approaches to designing privacy-aware systems and frameworks for data governance.
Create a lake database in Azure Synapse Analytics
Why choose between working with files in a data lake or a relational database schema? With lake databases in Azure Synapse Analytics, you can combine the benefits of both.
Introduction to Azure Data Lake Storage Gen2
Data lakes are a core element of data analytics architectures. Azure Data Lake Storage Gen2 provides a scalable, secure, cloud-based solution for data lake storage.
Data Streaming
Study techniques for real-time data processing and stream analytics.
Transform data with Spark in Azure Synapse Analytics
Data engineers commonly need to transform large volumes of data. Apache Spark pools in Azure Synapse Analytics provide a distributed processing platform that they can use to accomplish this goal.
There are no reviews yet.