LEADER 05633nam 2200757 a 450 001 9910975162503321 005 20251128202713.0 010 $a9786613650399 010 $a9781118237090 010 $a1118237099 010 $a9781280673467 010 $a128067346X 010 $a9781118223802 010 $a1118223802 035 $a(CKB)2670000000166865 035 $a(EBL)818030 035 $a(SSID)ssj0000658163 035 $a(PQKBManifestationID)12261033 035 $a(PQKBTitleCode)TC0000658163 035 $a(PQKBWorkID)10681659 035 $a(PQKB)10583540 035 $a(Au-PeEL)EBL818030 035 $a(CaPaEBR)ebr10542559 035 $a(CaONFJC)MIL365039 035 $a(OCoLC)782877157 035 $a(CaSebORM)9781118101124 035 $a(MiAaPQ)EBC818030 035 $a(OCoLC)808126487 035 $a(OCoLC)ocn808126487 035 $a(Perlego)1013255 035 $a(EXLCZ)992670000000166865 100 $a20111207d2012 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 00$aProfessional Microsoft SQL server 2012 integration services /$fBrian Knight ... [et al.] 205 $a1st ed. 210 $aIndianapolis, Ind. $cWiley Pub.$d2012 215 $a1 online resource (964 p.) 225 0 $aProgrammer to programmer Professional Microsoft SQL Server 2012 Integration Services 300 $a"Programmer to programmer." 300 $aIncludes index. 311 08$a9781118101124 311 08$a111810112X 327 $aProfessional: Microsoft® SQL Server® 2012 Integration Services; Contents; Introduction; Chapter 1: Welcome to SQL Server Integration Services; SQL Server SSIS Historical Overview; What's New in SSIS; Tools of the Trade; Import and Export Wizard; The SQL Server Data Tools Experience; SSIS Architecture; Packages; Control Flow; Data Flow; Variables; Parameters; Error Handling and Logging; Editions of SQL Server; Summary; Chapter 2: The SSIS Tools; Import and Export Wizard; SQL Server Data Tools; Creating Your First Package; The Solution Explorer Window; The Toolbox; The Properties Windows 327 $aThe SSIS Package DesignerControl Flow; Connection Managers; Variables; Data Flow; Parameters; Event Handlers; Package Explorer; Executing a Package; Management Studio; Summary; Chapter 3: SSIS Tasks; SSIS Task Objects; Using the Task Editor; The Task Editor Expressions Tab; SSDTCommon Properties; Looping and Sequence Tasks; Script Task (.NET); Analysis Services Tasks; Analysis Services Execute DDL Task; Analysis Services Processing Task; Data Mining Query Task; Data Flow Task; Data Preparation Tasks; Data Profiler; File System Task; Archiving a File; FTP Task; Getting a File Using FTP 327 $aWeb Service TaskRetrieving Data Using the Web Service Task and XML Source Component; XML Task; Validating an XML File; RDBMS Server Tasks; Bulk Insert Task; Using the Bulk Insert Task; Execute SQL Task; Workflow Tasks; Execute Package Task; Execute Process Task; Message Queue Task; Send Mail Task; WMI Data Reader Task; WMI Event Watcher Task; Polling a Directory for the Delivery of a File; SMO Administration Tasks; Transfer Database Task; Transfer Error Messages Task; Transfer Logins Task; Transfer Master Stored Procedures Task; Transfer Jobs Task; Transfer SQL Server Objects Task; Summary 327 $aChapter 4: ContainersTask Host Containers; Sequence Containers; Groups; For Loop Container; Foreach Loop Container; Foreach File Enumerator Example; Foreach ADO Enumerator Example; Summary; Chapter 5: The Data Flow; Understanding the Data Flow; Data Viewers; Sources; OLE DB Source; Excel Source; Flat File Source; Raw File Source; XML Source; ADO.NET Source; Destinations; Excel Destination; Flat File Destination; OLE DB Destination; Raw File Destination; Recordset Destination; SQL Server and Mobile Destinations; Data Mining Model Training; DataReader Destination 327 $aDimension and Partition ProcessingCommon Transformations; Synchronous versus Asynchronous Transformations; Aggregate; Conditional Split; Data Conversion; Derived Column; Lookup; Row Count; Script Component; Slowly Changing Dimension; Sort; Union All; Other Transformations; Audit; Character Map; Copy Column; Data Mining Query; DQS Cleansing; Export Column; Fuzzy Lookup; Fuzzy Grouping; Import Column; Merge; Merge Join; Multicast; OLE DB Command; Percentage and Row Sampling; Pivot Transform; Unpivot; Term Extraction; Term Lookup; Data Flow Example; Summary 327 $aChapter 6: Using Variables, Parameters, and Expressions 330 $aAn in-depth look at the radical changes to the newest release of SISS Microsoft SQL Server 2012 Integration Services (SISS) builds on the revolutionary database product suite first introduced in 2005. With this crucial resource, you will explore how this newest release serves as a powerful tool for performing extraction, transformation, and load operations (ETL). A team of SQL Server experts deciphers this complex topic and provides detailed coverage of the new features of the 2012 product release. In addition to technical updates and additions, the authors present you with a new set 606 $aDatabase management 606 $aRelational databases 615 0$aDatabase management. 615 0$aRelational databases. 676 $a005.7585 701 $aKnight$b Brian$025445 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910975162503321 996 $aProfessional Microsoft SQL server 2012 integration services$94351612 997 $aUNINA