This question is related to my previous question but is different in focus, so I'm creating a new question. I have a CSV file that has only column names in it, no data. I've created a Flat File Connection Manager in SSIS using Visual Studio 2012. I've checked Column Names in the first data row in the Connection Manager. Two column names must end in periods (Employee No., and Hrs.). Those columns are present with the periods in my CSV file. Comma, not period, is the delimiter in the Flat File Connection Manager. However, when I point the Connection Manager to the CSV file and click on Columns in the Connection Manager, the periods are replaced by spaces. Further, if I create a Flat File Destination, point it to my Flat File Connection Manager and run my SSIS package, the column names have spaces instead of periods. Is this a bug or am I doing something wrong?
.in its name, as having object names with them in makes for confusing code. – Larnu