开发者

SSIS FileNameColumnName output value incorrect

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!

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜