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
Ashwani Nanda, MCITP, MCDBA, MCSE, is a business intelligence developer with Avis-Europe where he focuses on data warehouse and CRM systems development projects, and business intelligence reporting solutions. He is the author of Hands-On Microsoft SQL Server 2005 Integration Services.
Keywords: HANDS-ON, MICROSOFT, SQL, SERVER, INTEGRATION, SERVICES, ASHWANI NANDA, SSIS, IMPORT, EXPORT, WIZARD, WORKFLOW, NUTS, BOLTS, CONTROL, FLOW, CONTAINERS, TASKS, ADMINISTRATION, SECURING, PACKAGES, ADVANCED, FEATURES, DATA, COMPONENTS, TRANSFORMATIONS, DEPLOYING, MIGRATING, TROUBLESHOOTING, PEFORMANCE, ENHANCEMENTS, EXTENDING, NEW, STAR, SCHEMA, WAREHOUSE, ARCHITECTURE, FOUNDATION, TOOL, BUSINESS, INTELLIGENCE, SOLUTION, METHODOLOGY, BI, SYSTEMS, MOVEMENT, MULTIPLE, ENTERPRISE, MARTS, DECISION, PROCESSES, ETL, EXTRACT, TRANSFORM, LOAD, INSTALLATION, SECURITY, DEVELOPERS, PROFESSIONALS, VENDORS, APPLICATIONS, EXERCISES, OBJECTIVES, CHALLENGES, SQL SERVER, MICROSOFT SQL SERVER 2008 HIGH AVAILABILITY WITH CLUSTERING & DATABASE MIRRORING, MICROSOFT SQL SERVER 2008 REPORTING SERVICES, MICROSOFT SQL SERVER 2008 A BEGINNER'S GUIDE, DELIVERING BUSINESS INTELLIGENCE WITH MICROSOFT SQL SERVER 2008, MICROSOFT SQL SEVER 2008 NEW FEATURES, MICROSOFT SQL SERVER 2008 ANALYTICS & DATA VISUALIZATION, DATABASES DEMYSTIFIED, SQL DEMYSTIFIED, SQL A BEGINNER'S GUIDE, SQL THE COMPLETE REFERENCE, BUSINESS INTELLIGENCE, BI, CRYSTAL REPORTS 2008 THE COMPLETE REFERENCE, BUSINESSOBJECTS XI THE COMPLETE REFERENCE, VISUALIZING INFORMATION WITH MICROSOFT OFFICE VISIO 2007, MICROSOFT OFFICE 2007 BUSINESS INTELLIGENCE 0071494243, BUSINESS INTELLIGENCE WITH MICROSOFT OFFICE PERFORMANCEPOINT SERVER 2007, SUCCESSFUL BUSINESS INTELLIGENCE, SAP BUSINESS INFORMATION WAREHOUSE REPORTING, CRCP CRYSTAL REPORTS CERTIFIED PROFESSIONAL ALL-IN-ONE EXAM GUIDE, ORACLE CRM ON DEMAND REPORTING, ORACLE DISCOVERER 10G HANDBOOK, APPLIED SAP BI 7.0 WEB REPORTS, THE POWER TO PREDICT, RESHAPING YOUR BUSINESS WITH WEB 2.0, CRM AT THE SPEED OF LIGHT, EVENT PROCESSING, PRACTICAL MDX QUERIES