Forum Discussion
cj_ruggles
9 years agoNew Contributor III
Hi - you need to remove the “CSV Formatter” Snap - the “CSV Parser” Snap converts the document stream to JSON, and the “SQL Server - insert” Snap expects JSON as an input. You can see that the “CSV Parser” Snap’s output is a diamond (binary), which won’t connect up to the “SQL Server - insert”'s circle (JSON).
If the CSV is in the exact structure of the SQL Server table (same field names) then you might be able to connect the “CSV Parser” directly to the “SQL Server - insert”. Otherwise you can put a Mapper in between to map between the CSV structure and SQL Server table structure.
Good luck!