1 / 20

Todo lo debes saber sobre SSIS en 1 hora!

Todo lo debes saber sobre SSIS en 1 hora!. Jose Chinchilla, MCTS, MCITP. Nuevo Ambiente de Desarrollo SQL Server 2012 Habilidades T-SQL a Super Poderes SSIS Demo BIDS Fuentes de Datos (Data Sources) y Vistas sobre fuentes de datos (Data Source Views) Paquetes (Packages)

yaphet
Download Presentation

Todo lo debes saber sobre SSIS en 1 hora!

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Todo lo debes saber sobre SSIS en 1 hora! Jose Chinchilla, MCTS, MCITP

  2. Nuevo Ambiente de Desarrollo SQL Server 2012 • Habilidades T-SQL a Super Poderes SSIS • Demo • BIDS • Fuentes de Datos (Data Sources) y Vistas sobrefuentes de datos (Data Source Views) • Paquetes (Packages) • Control Flow vs. Data Flow • Fuentes (Sources) & Destinos (Destinations) • Containers, Tasks, Transformations • Variables • Nuevo Modelo de Deployment

  3. Quees SSIS ? • Servicios de Integracion de SQL ServerSQL Server Integration Services • PlataformaparaIntegracion de datos y flujo de datosSSIS is a platform for data integration and workflow applications • Herramientapara la extraccion, transformacion y carga de datos (ETL) o extraccion, carga y transformacion de datos (ELT)Tool used for data extraction, transformation, and loading (ETL)and/or data extraction, loading then transforming (ELT) • Herramientapararealizaroperaciones DML, DDL, DCL, y soporte de TCLTool to make DML operation (Selects, Inserts, Updates, Deletes), DDL operations (Create/Drop Table), DCL operations (grant, revoke), TCL operatios (transactions, commit, rollback) • Herramientaparaautomatizarel mantenimiento y administracion de bases de datosTool to automate maintenance and tasks for SQL Server database administration

  4. SSIS – Pedro Navaja Transform Calculations Derive DB Tasks Convert Export OLTP DB Maintenance Import VB 2008 Script C# 2008 Script Insert Load WMI Read/Write Delete Data Profiling Update File System Tasks OLAP DB Maintenance Aggregations Extract Cast

  5. SSIS – Super poderes • XML

  6. SSIS – agrupacion de tasks Control Flow Data Flow Data Tasks Database Object Transfer Tasks Analysis Services Tasks File and Network Protocol Tasks Script and Program Tasks Package Execution Tasks WMI Tasks Database Maintenance Plan Tasks Other Maintenance Tasks Sources Destinations Transformations Learning SSIS under 1 hour

  7. Todoesto en 1 hora?

  8. SSIS tasks – el dia de hoy! Control Flow Data Flow Data Tasks Database Object Transfer Tasks Analysis Services Tasks File and Network Protocol Tasks Script and Program Tasks Package Execution Tasks WMI Tasks Database Maintenance Plan Tasks Other Maintenance Tasks Sources Destinations Transformations

  9. The Ambiente de Desarrollo

  10. Ambiente de Desarrollo • BIDS SQL Server 2012 • Shell de Visual Studio 2010

  11. Habilidades T-SQL a Super poderes SSIS

  12. Update (set based), Execute Stored Procs Recursiones - While (loops) File Operations (Copy,Delete,Move) sp_send_dbmail bcp Execute SQL Task For Loop & For Each Container File System Task Send Mail Task Bulk Insert Task T-SQL a SSIS • T-SQL • SSIS – Control Flow

  13. Select Insert Update (row by row) Case Convert, Cast IF Mathematic, Date, String Function & Cast Operations Merge Joins (left, right, full outer) Order by Union Group by (count, sum, avg) Data Flow Source Data Flow Destination OLE DB Command Conditional Split Data Conversion Derived Column Derived Column Merge Merge Join Sort Union All Aggregate T-SQL a SSIS • T-SQL • SSIS – Data Flow

  14. Lo nuevo de SSIS en SQL Sever 2012

  15. Lo nuevo de SSIS en SQL Sever 2012

  16. Lo nuevo de SSIS en SQL Sever 2012

More Related