SQL Server Integration Services (SSIS)
SSIS is a platform for building high-performance data integration solutions and workflow solutions. You can build extract, transform, and load (ETL) packages to update data warehouses, interact with external processes, clean and mine data, process analytical objects, and perform administrative tasks. Following are some of the features of SSIS:
• Graphical tools and wizards for building, debugging, and deploying SSIS packages
• Workflow functions, such as File Transfer Protocol (FTP), SQL statement execution, and more
• SSIS Application Programming Interfaces (APIs)
• Complex data transformation for data cleansing, aggregation, merging, and copying
• An email messaging interface
• A service-based implementation ...
Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
