Transform Raw Data Into Meaningful Business Intelligence with SSIS Deploy and manage high-performance data transformation solutions across your enterprise using the step-by-step techniques in this fully revised guide. Hands-On Microsoft SQL Server 2008 Integration Services, Second Edition explains the tools and methods necessary to extract conclusive business intelligence from disparate corporate data. Learn how to build and secure packages, load and cleanse data, establish workflow, and optimize performance. Real-world examples, detailed illustrations, and hands-on exercises are included throughout this practical resource. Build SSIS packages using the Import and Export Wizard and Business Intelligence Development Studio Create Loop and Task Host Containers with Control Flow Designer Administer SSIS from SQL Server Management Studio and dutil Secure packages using encryption, roles, signatures, and permissions Build-in memory lookups and transformations using the Data Flow Engine Extend functionality using custom scripts and ActiveX components Use SCD transformations to load data warehouses and data marts Learn to build a Star Schema and Parallel Data Warehouse Migrate Data Transformation Services 2000 and SSIS 2005 packages
A practical guide to mastering Microsoft SQL Server 2008 Integration Services Hands-On Microsoft SQL Server 2008 Integration Services makes learning SSIS easier through the use of extensive exercises structured around every component within the tool. The complex topics of embedding control flow tasks and containers in a data workflow and using data transformations in the data flow are covered with real-world examples and step-by-step methods.
Hands-On Microsoft SQL Server 2008 Integration Services features:
- Details on installation, control flow, data flow transformations, administration, security, and troubleshooting
- Two new chapters on extending SSIS through scripting/programming and standard methods for developing a data warehouse architecture
- New advanced examples throughout each chapter
- Hands-on exercises that are broken down into objectives, solution methodologies, numbered steps, and review for reinforcing techniques
- A focus on real-world data warehousing solutions that can be easily applied to your own business challenges
Comprehensive coverage of SSIS:
Introducing SSIS; Import and Export Wizard; SSIS Workflow Nuts and Bolts; Control Flow Containers; Control Flow Tasks; Administration; Securing Packages; Advanced Features; Data Flow Components; Data Flow Transformations; Deploying Packages; Migrating; Troubleshooting and Performance Enhancements; Extending SSIS; Star Schema Data Warehouse Architecture
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Transform Raw Data Into Meaningful Business Intelligence with SSISDeploy and manage high-performance data transformation solutions across your enterprise using the step-by-step techniques in this fully revised guide. Hands-On Microsoft SQL Server 2008 Integration Services, Second Edition explains the tools and methods necessary to extract conclusive business intelligence from disparate corporate data. Learn how to build and secure packages, load and cleanse data, establish workflow, and optimize performance. Real-world examples, detailed illustrations, and hands-on exercises are included throughout this practical resource. Build SSIS packages using the Import and Export Wizard and Business Intelligence Development Studio Create Loop and Task Host Containers with Control Flow Designer Administer SSIS from SQL Server Management Studio and dutil Secure packages using encryption, roles, signatures, and permissions Build-in memory lookups and transformations using the Data Flow Engine Extend functionality using custom scripts and ActiveX components Use SCD transformations to load data warehouses and data marts Learn to build a Star Schema and Parallel Data Warehouse Migrate Data Transformation Services 2000 and SSIS 2005 packages ## Transform Raw Data Into Meaningful Business Intelligence with SSIS Deploy and manage high-performance data transformation solutions across your enterprise using the step-by-step techniques in this fully revised guide. Hands-On Microsoft SQL Server 2008 Integration Services, Second Edition explains the tools and methods necessary to extract conclusive business intelligence from disparate corporate data. Learn how to build and secure packages, load and cleanse data, establish workflow, and optimize performance. Real-world examples, detailed illustrations, and hands-on exercises are included throughout this practical resource. * Build SSIS packages using the Import and Export Wizard and Business Intelligence Development Studio * Create Loop and Task Host Containers with Control Flow Designer * Administer SSIS from SQL Server Management Studio and dutil * Secure packages using encryption, roles, signatures, and permissions * Build-in memory lookups and transformations using the Data Flow Engine * Extend functionality using custom scripts and ActiveX components * Use SCD transformations to load data warehouses and data marts * Learn to build a Star Schema and Parallel Data Warehouse * Migrate Data Transformation Services 2000 and SSIS 2005 packages Deploy and manage high-performance data transformation solutions across your enterprise using the step-by-step techniques in this fully revised guide. Hands-On Microsoft® SQL Server® 2008 Integration Services, Second Edition explains the tools and methods necessary to extract conclusive business intelligence from disparate corporate data. Learn how to build and secure packages, load and cleanse data, establish workflow, and optimize performance. Real-world examples, detailed illustrations, and hands-on exercises are included throughout this practical resource. --Book Jacket Introducing SQL server integration services_ Getting started with wizards_ Nuts and bolts of the SSIS workflow_ Integration services control flow containers Integration services control flow tasks_ Administering integration services_ Securing integration services packages_ Advanced features of integration services_ Data flow components_ Data flow transformations_ Programming integration services_ Data warehousing and SQL server 2008 enhancements_ Deploying integration services packages Migrating to integration services 2008_ Troubleshooting and performance enhancements. Provides methodology and hands-on steps for mastering the latest release of Microsoft's proprietary business intelligence tool , including chapters on extending SSIS through scripting and standard methods for developing a data warehouse architecture. Original.
