Abstract: Welcome to SQL Server Integration Services 2008 (SSIS). This chapter will introduce SSIS and give an overview of what this course will cover. Also included in this chapter is an overview of SSIS and Visual Studio, common terms associated with SSIS, and what is new in SSIS 2008.
Number of Videos: 12
Total Run Time: 2 hours and 46 minutes
|
Abstract: This chapter will cover creating basic packages in SSIS. Other topics covered in this chapter include importing data with the Wizard, including Microsoft Access Tables and Excel Spreadsheets and Workbooks, annotating, documenting and formatting SSIS packages, working in BIDS, and managing projects with SSIS packages.
Number of Videos: 10
Total Run Time: 1 hour and 57 minutes
|
Abstract: This chapter will delve a little deeper into SQL Server Integration Services 2008. Topics covered in this chapter include different options for saving files, the SSIS package store, version control, ProtectionLevel options and settings, logging, auditing, and troubleshooting.
Number of Videos: 12
Total Run Time: 2 hours and 25 minutes
|
Abstract: This is a long, but very important chapter that covers common SSIS tasks. Some tasks covered in this chapter include the For Loop, the Foreach Loop Container, precedence constraints, SSAS, WMI tasks, FTP tasks, sending email with script tasks, data types, and much, much more!
Number of Videos: 76
Total Run Time: 15 hours and 30 minutes
|
Abstract: This chapter is all about making your SSIS packages more dynamic using variables, expressions, and package configurations. Some other topics covered in this chapter include an overview of the different types of variables and expressions in SSIS, using the foreach container for several purposes, the Execute SQL task, using environment variables in package constraints, and much more!
Number of Videos: 28
Total Run Time: 5 hours and 43 minutes
|
Abstract: In this chapter you will take what you have learned so far in the course and learn how to apply it to real world situations you will encounter as an SSIS developer. In this chapter Scott Whigham will show you how to loop through all files in a folder and load them into SQL Server, export XML data from SQL Server, perform and evaluate the performance of bulk loads, perform incremental updates, use an FTP package, populate an Analysis Services cube, and much more!
Number of Videos: 28
Total Run Time: 5 hours and 39 minutes
|
Abstract: This chapter is all about scripting, using .NET, and assemblies in SSIS. This is an especially important chapter for anyone that needs to use .NET in their career as an SSIS developer. In this chapter Scott will cover what you can do with .NET in SSIS, using the script task with both C# and VB, how to read and write variables, using custom and third party .NET assemblies, creating more presentable excel reports, sending nicer looking emails, importing and exporting MP3 files from a database, and much more!
Number of Videos: 23
Total Run Time: 4 hours and 36 minutes
|
Abstract: This chapter is all about package execution, security, and scheduling, which are all very important concepts in SSIS. In this chapter, Scott will show you how to assign package roles, introduce the different options for executing SSIS packages, and introduce context in SSIS package execution. Other topics covered in this chapter are security, scheduling SSIS packages as SQL Server jobs, using package configurations and variables to create dynamic scheduled jobs, using proxies and credentials, and much more.
Number of Videos: 12
Total Run Time: 2 hours and 2 minutes
|
Abstract: The final chapter in course 158 is all about migrating and upgrading from DTS in SQL Server 2000 to SSIS 2008. The biggest challenge you will face in migrating to SSIS 2008 is how to handle packages. In this chapter Scott will show you how to run the upgrade advisor, introduce the various options for migrating from SQL Server 2000 DTS to SSIS 2008, using the package migration wizard, copying DTS packages to SQL Server 2008, and much more!
Number of Videos: 9
Total Run Time: 1 hour and 28 minutes
|