开发者

SSIS FileNameColumnName output value incorrect

开发者 https://www.devze.com 2023-01-21 10:12 出处:网络
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 g

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

精彩评论

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