What is the difference between a control flow task and a control flow container?
Control flow tasks perform operations, whereas containers coordinate and group tasks.
Example: a foreach Loop Container can look through the fi les in a system folder, and a file System Task embedded within the container can then move the files to a new folder location.
SSIS New Features in SQL Server 2008
Scripting Task
SQL Server 2008 scripting is built on the improved VSTA (Visual Studio Tools for Applications) rather than the VSA (Visual Studio for Applications) scripting engine. VSTA is allows us to build scripts in both C# and VB.NET.
Data Profiling Task
No comments:
Post a Comment