'Add comma delimiter to SSIS flatfile destination
I have an ETL package that I am using as a template for something similar.
For context, I am pulling a list of customer numbers from the database and sending it as an Excel file to a system that processes the numbers and sends back a file with extra information.
I have mirrored the exact process and properties that the current ETL package uses however I am not receiving any data back because the customer numbers are not delimited in the excel file.
If I use the browse option in the flat file connection manager and select an excel file that has delimited values by comma, it shows the numbers being separated by comma in the preview box but when I execute the package, the file that is being sent to the server for processing still does not separate the values by comma.
This is when I select a file previously sent to the server that is not delimited - Without commas
This is when I select a file previously sent to the server that is delimited - With commas
This is what I want the excel sheet to produce
I have tried to set the file as delimited by comma but that doesn't do it either.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|