Skip to main content

Posts

Showing posts from July 21, 2011

SSIS Tasks

Data Flow Task Data Flow Task : This task extracts data from a source, allows for transformations of that data, and then the data is loaded into a target data destination. Data Preparation Tasks File System Task : This task allows the user to copy/move/delete files and directories on a file system. FTP Task : This task allows the user to copy/move/delete files and directories over FTP. Web Service Task : This task allows the user to execute a Web service method and store the results XML Task : This task is used to work with XML data. XSLT can be used along with XPath to validate, compare and merge documents. The results of this can then be stored. Data Profiling Task : This task can be used for checking and validating data quality. Profiles can be set up and checked for varius data quality issues such as, column length issues, column patterns, column statics, etc. Workflow Tasks Execute Package Task : This task will run other SQL Server Integration Services packages.