Abstract: This chapter is really designed to be your entry point into our website. If you've never used SSIS before or you are migrating to SSIS from DTS, you'll want to start here and watch these videos to learn the basic terms, screens and ideas of using SSIS.
Number of Videos: 26
Total Run Time: 4 hours and 59 minutes
|
Abstract: The more packages your organization has, the more difficult it is to manage SSIS. This chapter focuses on how to effectively manage SSIS and discusses Security topics (like roles, service accounts, package creators/owners and the like), as well as storage options (i.e., should you save your package as a file or inside SQL Server?). Also included are tips for change management such as documenting, printing and managing your SSIS packages
Number of Videos: 35
Total Run Time: 6 hours and 18 minutes
|
Abstract: Variables in SSIS allow you to create packages that can be configured at runtime and Expressions (new in SSIS) allow you to customize your package even further at runtime. This chapter focuses on using Expressions and Variables for recordset iteration, with the Foreach loops, as connection strings, and much, much more. You'll also learn about accessing variables in Scripting such as Dts.Variables("MyVariable").Value
Number of Videos: 13
Total Run Time: 2 hours and 31 minutes
|
Abstract: SSIS includes several containers and this chapter covers them all. We'll take you through the details of working with the For Loop Container Task, the Foreach Look Container Task, and the Sequence Container Task in this chapter.
Number of Videos: 4
Total Run Time: 1 hour and 11 minutes
|
Abstract: The foundation of SQL Server Integration Services is the Data Flow-based tasks - without them, you are pretty limited in your base of operations. This chapter helps you learn the basics of the data transformations, data sources, data destinations and really helps you get a solid foundation in SSIS.
Number of Videos: 29
Total Run Time: 4 hours and 59 minutes
|
Abstract: The Script Task and the Script Component Task are two of the most flexible tasks but also require you to know a great deal about the Visual Studio for Applications (VSA) and other CLR-based languages (a.k.a. .NET languages) such as C# and Visual Basic (or Visual Basic .NET as it's referred to inside SSIS). This chapter of videos is designed to help you become more comfortable working with scripting/.NET-language-based tasks
Number of Videos: 12
Total Run Time: 2 hours and 44 minutes
|
Abstract: One of the most confusing (and annoying) aspects of SSIS for someone just starting out is how you actually schedule SSIS packages and execute them outside of the SSMS (SQL Server Management Studio) or BIDS (Business Intelligence Development Studio - a.k.a. the Visual Studio). This chapter is here to help you understand the how-to of package execution and scheduling including information on how to schedule SSIS package as a job, how to execute SSIS package via C#, how to execute SSIS packages with VB.NET, and much more.
Number of Videos: 11
Total Run Time: 2 hours and 12 minutes
|
Abstract: There is so much to cover here - DTS is essentially gone and SSIS has taken it's place. The problem (for you)? SSIS is so different from DTS that it only helps a little bit if you knew DTS. Is it better to start out fresh with SSIS and not know DTS at all? Good question!
Number of Videos: 18
Total Run Time: 4 hours and 14 minutes
|
Abstract: These videos are basically homeless. They have therefore been placed into the chapter until we find a better home for them!
Number of Videos: 14
Total Run Time: 2 hours and 36 minutes
|