In a Flat File Source in SSIS I am trying to u开发者_高级运维se 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!
精彩评论