SQL Server Integration Services

摘要

Last month we took a look at the new SQL Server Integration Services (SSIS) component that is part of SQL Server 2005 and replaces the old DTS system. In this we saw that SSIS packages can be created in the Business Intelligence Development Studio (BIDS) and can be done using a design view where you can design the entire process. Each package consists of a Control Flow - a workflow like component that decides which steps are to be executed using tasks; and Data Flows - which do the actual data transformations. We take a deeper look into the latter component in this article.