This five-day instructor-led course is intended for IT professionals who need to learn how to use SSIS to build, deploy, maintain, and secure Integration Services projects and packages, and to use SSIS to extract, transform, and load data to and from SQL Server. Module 1: SSIS OverviewThis module explains the purpose of SSIS and teaches how to use the Import/Export Wizard to exchange data between data structures.Import/Export WizardExporting Data with the WizardCommon Import ConcernsQuality Checking Imported/Exported DataLab of Module 1:SSIS OverviewUse the Import/Export Wizard from SSMSAfter completing this module 1, students will be able to:Export data with the wizard.Import data with the wizared.Do a quality check on imported and exported data. Module 2: Working with Solutions and ProjectsIn this module, students learn to work with SQL Server Data Tools (SSDT) to design and deploy reports.Working with SQL Server Data ToolsUnderstanding Solutions and ProjectsWorking with the Visual Studio InterfaceLab of Module 2:Working with Solutions and ProjectsImport and run a package in SSDT-BIAfter completing this module 2, students will be able
