SSIS FileNameColumnName output value incorrect – Education Career Blog

In a Flat File Source in SSIS I am trying to use the FileNameColumnName property (from Advanced Properties) to populate a field in a database. It seems quite straightforward – I simply gave it a name and mapped it to a field in my OLE DB. The problem is, however, that it DB field is populated with the letter ‘C’, and nothing more.

My data type is varchar.

Any ideas?


Ooops. Sorted it out – had to change the output to Unicode (nvarchar in the OLE DB). Thanks!

Leave a Comment