Sign-up now and get instant access
Leave a comment
Customized training to master new skills and grow your business.
Beginner to advanced classes taught by Microsoft MVPs and Authors.
In-depth boot camps take you from a novice to mastery in less than a week.
Season Learning Pass
Get access to our very best training offerings for successful up-skilling.
Stream Pro Plus
Combine On-Demand Learning platform with face-to-face Virtual Mentoring.
Quick references for when you need a little guidance.
Summaries developed in conjunction with our Learn with the Nerds sessions.
Digital goodies - code samples, student files, and other must have files.
Stay up-to-date on all things Power BI, Power Apps, Microsoft 365 and Azure.
Earn money by driving sales through the Pragmatic Works' Training Affiliate Program.
It's time to address your client's training needs.
Learn how to get into IT with free training and mentorship.
Discover the faces behind our success: Meet our dedicated team
How can we help? Connect with Our Team Today!
Find all the information you’re looking for. We’re happy to help.
Why is using SSIS in Azure important? Companies receive data from outside their organization and need to perform data-quality routines to standardize and clean the data before loading it into their systems. One obstacle many organizations face when migrating databases is that SQL Server Integration Services (SSIS) still needed to run on a server, requiring a SQL Server license. With the announcement of the preview of SSIS in Azure, Microsoft has cleared this portion of the migration path.
In our brand-new SSIS in the Cloud course we will take a deep dive into SSIS, a tool you’re already familiar with, and guide you on how to utilize this tool in Azure. Still not convinced if this course is right for you? Join course creator Manuel Quintana as he answers 5 questions about our new SSIS in the Cloud course.
Who is this class for?
Our SSIS in the Cloud course is designed for users who want to utilize SSIS in Azure but are not quite ready for Azure Data Factory. If you’re interested in SSIS, Azure Storage, Azure Data Factory or Azure itself then this is the class for you.
What skills are needed for this class?
In order to make sure you succeed in this class we do recommend a basic knowledge and understanding of Integrations Services. If you have attended our Introduction to SSIS, then you understand control flows, dataflows, and how to create connection managers, which is perfect for this course. We will discuss and create new packages, but we will not dwell on the design process. You will gain a better understanding of how to leverage these Azure components in SSIS and canvas through this course.
Why is this class so important?
SSIS has been around for years and is a very useful tool in extracting, transforming, and loading data. With the popularity of Azure and its various services, you can now keep your SSIS packages and move that information into your cloud environment. This service will allow you to stay in the now as well as sticking to a familiar service.
Why is this class different?
In this class we pride ourselves on the delivery of this content. Unlike other resources, we have put together the appropriate order and process of learning SSIS in the cloud that will allow you to easily understand the content, so you can revisit specific points as they arise in the real world. We will go through various processes on how to create packages in Azure SQL DB, Azure Data Factory and Azure Data Instances. Our goal is to go through all these processes, but in a controlled and organized matter so you can get the most from this class.
What are the key takeaways from this course?
At the end of this course, you will have a solid understanding of the capabilities and offerings Azure can provide to your organization. You will feel confident using SSIS and in Azure. If you are deciding whether using SSIS in Azure is the right path for your organization, or should you to jump over it and design with Azure Data Factory, this is the course for you.
We hope these 5 questions have clarified the importance of SSIS in the Cloud, as well if this course is right for you. If you are ready to merge SSIS with your Azure environment, visit our website to subscribe to our new class or click the link below for your free On-Demand Learning trial.
Join other Azure, Power Platform and SQL Server pros by subscribing to our blog.