6 Apr 2012

SSIS load text file name into table for ETL auditing Unicode error

The old saying still rings true, you get what you pay for, pay nothing, expect nothing, this excellent post details how to read the file name but this post will cause a unicode error because the its missing details at this part



"Be sure to change the DATA TYPE from UNICODE to STRING.  Select OK to confirm changes."  This is impossible unless you do this

Click on Show Advanced Editor





to change the data type to String (see screen shot below)







Then your data type will be string (see below)


And then you will not have unicode errors.



No comments:

Post a Comment