- Creating SSIS packages
- Coding and looping tasks
- Managing and administering SQL with SSIS tasks
- Optimizing data for extraction
- Making packages dynamic with variables and parameters
- Using sequences in a container
- Performing joins
- Handling errors
- Working with XML
Skill Level Intermediate
- [Voiceover] Hi, my name is Ron Davis, and I'm the author of this course on Microsoft SQL Server Integration Services. SQL Server Integration Services is called a service because it is dependent on the SQL database engine having been installed. We use Integration Services to perform ETL, extract, transform, and load, where we reach out to flat files, the web, FTP, et cetera, and bring the data in and then transform it.
In this course, we'll be looking at the basic tools that allow you to create SQL Server Integration Services packages and how to connect those packages to your data sources. From there, I'll walk you through the basic tasks of preparation and loading your data so you can execute scripts, transform your data, and incorporate logic into how your data is treated. Along the way, we'll take a look at using events, debugging your workflows, and incorporating best practices, so let's get started on our journey to understand Integration Services.
Querying Microsoft SQL Server 2012with Gerry O'Brien5h 35m Beginner
2. SQL Server Integration Services Tools
3. SQL Server Integration Services Tasks
4. Data Flow
5. Variables, Parameters, and Expressions
6. Performing Joins
7. Debugging SQL Server Integration Services Packages
8. Common Designs in SQL Server Integration Services
Where to go next37s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.