SSIS strips periods off column names in Flat File Connection Manager

  • 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?

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply