Regular Price: £210 Batch Price: From £210 📅 View Dates & Prices Group Booking Discount: From £120 per person 🧮 Calculate & Book 1-to-1 Training: £240 📋 Booking Request Form Course Overview Our SQL Server Integration Services (SSIS) is an instructor-led virtual classroom-based training course that teaches attendees how to perform data integration and transformation by using SSIS. At the end of this course, attendees will have a good understanding of SSIS concepts and creating SSIS packages. Requirements This course is suitable for those who already have basic knowledge on Microsoft SQL Server database and table design, SQL, T-SQL and Stored Procedure. Our Database Design with Microsoft SQL Server Training Courses cover all of the prerequisites. We highly recommend you complete the following course(s) before attending the SQL Server Integration Services (SSIS) course: SQL for Beginners Course Content Getting Started with SSIS What is SSIS? Data Warehouse Overview Development Tools Create a Solution and Project Control Flow Control Flow Basics Tasks Precedence Constraint Containers Containers Data Flow – I Data Flow Basics Data Sources - I Data Sources – II Data Destinations OLEDB, Excel, Flat File Data Flow – II Data Flow Transformation – Introduction Row Transformation Aggregate, Sort Transformations Deployment Deployment and running SSIS Projects Schedule packages with SQL Server Agent Course Dates, Prices & Enrolment All Training Physical Classes Virtual Classes UTC British Time (UK, Ireland, Iceland) Central European Time (France, Germany, Sweden) Eastern European Time (Finland, Cyprus) Eastern Time (New York, Toronto, Montreal) Central Time (Chicago, Houston, Winnipeg) Mountain Time (Calgary, Denver, Edmonton) Mountain Time (Phoenix) Pacific Time (Los Angeles, Seattle, Vancouver) Singapore Time Arabic Standard Time (Qatar, Saudi Arabia) Gulf Standard Time (UAE, Oman) Australian Eastern Time (Sydney, Melbourne) Western Australia Time (Perth) New Zealand Time China Standard Time (China, Taiwan, Hong Kong) Scroll right for more details There is no date for this course at this moment. Please complete the BOOKING REQUEST FORM below or come back to this page again later. Price Calculator & Booking Request Form Calculate prices for Corporate, 1-on-1 or group training and request a booking. Do you have a special training requirement or unable to find any suitable training date? Please complete and submit the booking request form, if you want to: book a course on different dates book for a group of delegates book corporate training book a customised training book a one-on-one training The price person is less when you book a course for more people. You can find the price per person and the total cost by changing the values of the training hours and the number of people below: How many hours? How many people? Total Cost Price per person Preferred Dates and Times Any other information Career Path This is a possible career path after completing this course: BI Developer / Data Warehouse Developer > Senior BI Developer / Integration Consultant
12 June 2014 Backup a database using SQL Server Management Studio This simple step-by-step guide, clearly illustrated with screenshots, will take you through the process of backing up an SQL database.
24 February 2016 BIML, The next milestone for SSIS Developers The important aspects about BIML (Business Intelligence Markup Language) and its usage.
17 December 2025 Data Warehousing Is Not Becoming Obsolete Due to Cloud-Based Data Data warehousing is not becoming obsolete because organisations still require a centralised, governed environment to clean, integrate, and analyse data for reliable decision-making. Cloud technologies have instead modernised data warehousing by making it more scalable, flexible, and cost-effective through cloud-native platforms rather than replacing its core purpose.
29 March 2020 Downloading and Restoring the AdventureWorks2017 sample database In this tutorial you will learn how to download and restore the AdventureWorks sample database in Microsoft SQL Server 2017.
19 April 2020 Installing Microsoft SQL Server on Mac OS using Docker You can install SQL Server on to a Mac using Docker. You will get not full feature of SQL Server Management studio though.
30 March 2020 Installing SSDT for Visual Studio 2017 In this tutorial, you will learn how to install SQL Server Data Tools (SSDT) for Visual Studio 2017.
27 March 2020 Microsoft SQL Server 2017 Step by Step Installation Guide In this article, you will learn how to install the Microsoft SQL Server 2017 Developer Edition.
14 August 2024 SQL for Data Analysis: Unlocking Insights from Your Data In this blog post, we'll explore how SQL can be used for data analysis, focusing on key concepts, techniques and examples that will help you harness the power of SQL to extract meaningful insights from your data.
10 August 2020 Top Reasons to Use Business Intelligence Tools In this article we will explore the benefits that come with the use of business intelligence tools.
29 March 2020 Visual Studio 2017 Step by Step Installation Guide In this tutorial, you will learn how to install Visual Studio Community 2017 step by step.
17 September 2025 Why SQL is a Must-Have Skill for Every Modern Employee SQL is a critical business skill that empowers employees to access, analyse, and act on data directly, leading to faster, smarter decisions and a more agile, data-driven company culture. This article explains how SQL knowledge across an organisation, from marketing and sales to finance and operations, unlocks faster, deeper insights directly from source data.