The Read CSV task can read data from delimited text files and load that data into a RowSet variable. That variable can then be used to import the data into a database or translate it into another file type like Excel, fixed-width, or
XML
.
If the input data does not have any special formatting requirements, then you can generally just specify the Input File and Output RowSet Variable attributes in the Read CSV task. However, if some of the fields have special formatting (for example, dates, trailing spaces, etc.), then you will want to Specify Data Options that can be added from the