microsoft sql server 2012 integration services (ssis)
TRANSCRIPT
![Page 1: Microsoft SQL Server 2012 Integration Services (SSIS)](https://reader033.vdocuments.us/reader033/viewer/2022061612/56649e355503460f94b23bcf/html5/thumbnails/1.jpg)
Microsoft SQL Server 2012Integration Services (SSIS)
![Page 2: Microsoft SQL Server 2012 Integration Services (SSIS)](https://reader033.vdocuments.us/reader033/viewer/2022061612/56649e355503460f94b23bcf/html5/thumbnails/2.jpg)
SQL Server Data Tools (SSDT)
the central tool that you’ll spend most of your time in as an SSIS developer
the tool’s foundation is the Visual Studio 2010 interface
![Page 3: Microsoft SQL Server 2012 Integration Services (SSIS)](https://reader033.vdocuments.us/reader033/viewer/2022061612/56649e355503460f94b23bcf/html5/thumbnails/3.jpg)
SSIS
extraction, transformation and loading (ETL) platform
major player in the ETL market package
a core component of SSIS collection of tasks that execute in an orderly
fashion task
an individual unit of work
![Page 4: Microsoft SQL Server 2012 Integration Services (SSIS)](https://reader033.vdocuments.us/reader033/viewer/2022061612/56649e355503460f94b23bcf/html5/thumbnails/4.jpg)
Tasks
![Page 5: Microsoft SQL Server 2012 Integration Services (SSIS)](https://reader033.vdocuments.us/reader033/viewer/2022061612/56649e355503460f94b23bcf/html5/thumbnails/5.jpg)
Data Flow Elements
Destination
Source
![Page 6: Microsoft SQL Server 2012 Integration Services (SSIS)](https://reader033.vdocuments.us/reader033/viewer/2022061612/56649e355503460f94b23bcf/html5/thumbnails/6.jpg)
Data Flow Elements
Transformations
![Page 7: Microsoft SQL Server 2012 Integration Services (SSIS)](https://reader033.vdocuments.us/reader033/viewer/2022061612/56649e355503460f94b23bcf/html5/thumbnails/7.jpg)
Data Flow Elements
More transformations..
![Page 8: Microsoft SQL Server 2012 Integration Services (SSIS)](https://reader033.vdocuments.us/reader033/viewer/2022061612/56649e355503460f94b23bcf/html5/thumbnails/8.jpg)
SSIS - demoAverageRate CurrencyID CurrencyDate EndOfDayRate
![Page 9: Microsoft SQL Server 2012 Integration Services (SSIS)](https://reader033.vdocuments.us/reader033/viewer/2022061612/56649e355503460f94b23bcf/html5/thumbnails/9.jpg)
Dimension Load
Slowly Changing Dimension (SCD) Wizard is a Data Flow object that takes all the complexity out of creating a load process for your dimension table.
![Page 10: Microsoft SQL Server 2012 Integration Services (SSIS)](https://reader033.vdocuments.us/reader033/viewer/2022061612/56649e355503460f94b23bcf/html5/thumbnails/10.jpg)
Dimension Load
![Page 11: Microsoft SQL Server 2012 Integration Services (SSIS)](https://reader033.vdocuments.us/reader033/viewer/2022061612/56649e355503460f94b23bcf/html5/thumbnails/11.jpg)
Dimension Load
![Page 12: Microsoft SQL Server 2012 Integration Services (SSIS)](https://reader033.vdocuments.us/reader033/viewer/2022061612/56649e355503460f94b23bcf/html5/thumbnails/12.jpg)
Dimension Load
![Page 13: Microsoft SQL Server 2012 Integration Services (SSIS)](https://reader033.vdocuments.us/reader033/viewer/2022061612/56649e355503460f94b23bcf/html5/thumbnails/13.jpg)
Bibliography
Brian Knight, Devin Knight, Mike Davis, Wayne Snyder, Microsoft SQL Server 2012 Integration Services, 2012
Francis Rodrigues, Michael Coles, Davd Dye, Pro SQL Server 2012 Integration Services, APRESS 2012
Brian Knight, Erik Veerman, Jessica M. Moss, Mike Davis, Chris Rock, PROFESSIONAL Microsoft SQL Server 2012 Integration Services, Wiley 2012