Thank you, Rick. In this scenario CSV 2 is the final output of the project. I'm curious what the size parameter is used for in the Modify Rowset task, since it doesn't seem to be used for data truncation. Am I missing the point?

I'm having trouble reading scientific notation from a CSV. I am trying to convert to DECIMAL using the Read CSV task using different patterns, but I can't get past this error: Column data '3.2e+06' is not valid for its data type 'DECIMAL' I've tried using various patterns with 'E' such as 'E##' etc....

In a project which follows the pattern Read CSV 1 -> Modify Rowset -> Write CSV 2 , I am concatenating two fields from CSV 1 with a New Column in the Modify Rowset task, and I need to truncate the resulting string to 30 characters before writing to CSV 2 . I expected that setting the Modify Rowset t...

I'm using the HTTPS Task and postRawData to send a SOAP request which responds with a SOAP envelope that contains a CDATA text value in the body. The response gets written to a file with the CDATA tags removed and the ensuing text encoded for XML, ie. '<' becomes '<' and '>' becomes '>'. Is there a ...