Languages:English (Unknown), English (Original Language), English (Published) Media:Paperback Edition:2 Pages:720 Number Of Items:1 Shipping Weight (lbs):2.6 Dimensions (in):8.9 x 7.3 x 1.4
ISBN:0071736409 EAN:9780071736404 ASIN:0071736409
Publication Date:September 2, 2010 Availability:Usually ships in 1-2 business days
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
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED ‘AS IS’ AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME.
