Item Details

Print View

Pro SQL Server 2012 Integration Services [electronic resource]

Rodrigues, Francis; Coles,Michael; Dye,David
Format
EBook; Book; Online
Published
New York : Apress L. P. June 2012
Edition
New Edition
Language
English
ISBN
9781430236924, 1430236922 (Trade Paper)
Summary
Annotation
Description
Mode of access: World wide Web.
Copyright Not EvaluatedCopyright Not Evaluated
Technical Details
  • Access in Virgo Classic
  • Staff View

    LEADER 03775nam a22003852 4500
    001 u5833007
    003 SIRSI
    005 20121108060455.0
    006 m d
    007 cr n
    008 110806e20120627nyu s|||||||| 2|eng|d
    020
      
      
    a| 9781430236924
    020
      
      
    a| 1430236922 (Trade Paper) c| USD 49.99 Retail Price (Publisher) 9| Active Record
    024
    3
      
    a| 9781430236924
    035
      
      
    a| (WaSeSS)ssj0000738884
    037
      
      
    b| 00152887
    040
      
      
    a| BIP US d| WaSeSS
    100
    1
      
    a| Rodrigues, Francis e| Author
    245
    1
    0
    a| Pro SQL Server 2012 Integration Services h| [electronic resource]
    250
      
      
    a| New Edition
    260
      
      
    a| New York : b| Apress L. P. c| June 2012
    520
    8
      
    a| Annotation b| Pro SQL Server 2012 Integration Servicesteaches how to take advantage of the powerful extract, transform, and load (ETL) platform included with Microsoft SQL Server 2012.Youll learn to build scalable, robust, performance-driven enterprise ETL solutions that save time and make money for your company. You'll learn to avoid common ETL development pitfalls and how to extend the power of your ETL solutions to include virtually any possible transformation on data from any conceivable source. SQL Server Integration Services (SSIS) facilitates anunprecedented ability to load data from anywhere, perform any type of manipulation on it, and store it to any source.Whether you are populating databases, retrieving data from the Web, or performing complex calculations on large data sets, SSIS gives you the tools to get the job done. And this book gives you the knowledge to take advantage of everything SSIS offers.Helps you design and develop robust, efficient, scalable ETL solutionsWalks you through using the built-in, stock componentsShows how to programmatically extend the power of SSIS to cover any possible scenarioWhat youll learnCreate an SSIS package from scratchDeploy an SSIS package to any environmentBenchmark the performance of SSIS packages using common toolsOptimize SSIS data flows to achieve maximum performanceUse .NET to extend the power of the stock SSIS toolkitProfile and scrub data during the ETL processWho this book is forPro SQL Server 2012 Integration Servicesis for ETL developers, SQL developers, and database administrators at all levels of experience who want to harness the power of SSIS on SQL Server 2012. Whether you are using SSIS to build small, one-off ETL packages in a small shop, or building enterprise-wide ETL solutions in a Fortune 500 company, this book gives you the information you'll need to build powerful, scalable, and efficient ETL solutions at any level of complexity.Table of ContentsIntroducing Integration ServicesBIDS and SSMSHello World!Your First SSIS 2012 PackageConnection ManagersControl Flow BasicsAdvanced Control Flow TasksSource and Destination AdaptersData Flow TransformationsVariables, Parameters, and ExpressionsScriptingEvents and Error HandlingData Profiling and ScrubbingLogging, Auditing and Data LineageHeterogeneous Sources and DestinationsData Flow Tuning and OptimizationParent-Child Design PatternDimensional Data ETLBuilding Robust SolutionsDeployment Model
    538
      
      
    a| Mode of access: World wide Web.
    655
      
    0
    a| Electronic books.
    690
      
      
    a| Sql Server
    690
      
      
    a| Integrated Services Digital Networks
    692
      
      
    a| Computers x| Database Management x| General
    692
      
      
    a| Computers x| Data Transmission Systems x| Broadband
    700
    1
      
    a| Coles,Michael e| Author
    700
    1
      
    a| Dye,David e| Author
    710
    2
      
    a| Safari Books Online
    856
    4
    0
    u| http://RE5QY4SB7X.search.serialssolutions.com/?V=1.0&L=RE5QY4SB7X&S=JCs&C=TC0000738884&T=marc
    596
      
      
    a| 1
    999
      
      
    a| XX(5833007.1) w| WEB i| 5833007-1001 l| INTERNET m| UVA-LIB t| INTERNET
▾See more
▴See less

Availability

Google Preview

Google Books Preview

Read Online