SSIS CSV Parser TransformSSIS CSV Parser Transform can parse CSV string into multiple columns and rows (Helpful to extract data from raw CSV string stored as database column or coming from other source). It also supports Pivot mode so you can convert single CSV string value into Rows. Features
|
 |
| Download Help File Buy | View All Tasks |
SSIS CSV Parser Transform – Parse CSV Document
We insert an CSV example in the component and uncheck the ‘first row has a column header’
SSIS CSV Parser Transform – Split database CSV column string
The output from Dummy data source and CSV parser
SSIS CSV Parser Transform – Pivot Option (Normalize CSV string)
Example with pivot columns to row option
SSIS CSV Parser Transform – Pivot Option (Runtime view – Normalize CSV string)
The result with Pivot column to rows
Articles / Tutorials
Click here to see all articles for [SSIS CSV Parser Transform] category
 |
Parse CSV string into multiple columns and rows using SSISIntroduction In our previous blog we saw How to write data into CSV file in SSIS (GZip / Split). Now in this blog, we will Parse CSV string into multiple columns and rows using SSIS CSV Parser Transform can (Helpful to extract data from raw CSV string stored as database column or coming from other source). It also […] |
