The Write CSV task will write a delimited text file based on the contents of a RowSet variable. That variable can contain data from a database or from another file type such as Excel, fixed-width, or
XML
.
Writing a CSV file can be as easy as specifying the Input RowSet Variable and Output File attributes. By default, the file will be comma delimited and the contents will be identical to the data found in the RowSet variable.