This article is a bare bones introduction to SQL Server Integration Services (SSIS), with an emphasis on the SSIS development environment. SSIS is Microsoft's full feature extract-transform-load (ETL) tool in SQL Server 2005, 2008, and R2. SSIS is used to extract data from any of a myriad of sources, such as SQL Server databases, flat files, Excel files, Oracle and DB2 databases, etc. It performs data manipulation and transformation on the data and delivers it to one or more data destinations.
Hot off the presses at Microsoft, this book is for anyone who has an interest in SQL Server 2008 R2 and wants to understand its capabilities.
Access custom scripts, installation and upgrade guides, management tips, high availability strategies, database consolidation techniques, and more...
While SSIS is part of the SQL Server suite of tools, and is very adept at handling SQL Server-to-SQL Server ETL operations, it easily handles many other source and destination you have a library for. Potential applications include scrubbing and exporting Excel data for output to network directories, or third party database ETL transformations (e.g., Oracle-to-Oracle data loads). Let's create a new SSIS package and take a brief look at the major components and features of the [...]
No comments:
Post a Comment