SQL Server Integration Services: Difference between revisions

Revision as of 05:56, 21 February 2006

Revision as of 09:11, 22 February 2006

Line 24:

===Features of the data flow task===

The Data Flow task, arguably the most important task in the product, features a different design surface than that of the workflow. Data flows are edited withnwithin the same design tool, of course. The user can draw data sources, transforms, and data destinations connecting them together in order to achieve the transfer and transforms they desire.

Data sources can connect to any number of source types using [[OLEDB]] or ADO. They generally execute a SQL statement (including a stored procedure) to retrieve rows, though there are exceptions. Most notably, a flat file data source allows reading from text files, and an XML adapter can source data from XML files. Similarly, data destinations write data to their target by executing a statement on its connection, or writing to a file.