I am assigned to a task and this task sounds quite easy: load data from a csv file into an access 2003 table. I used SSIS2008 to complete this job and it appears the traditional unicode and nonunicode conversion errors was blocking the development. After investigation, I realized that all text columns in access are unicode-enabled default. Since all incoming columns are converted to DT_STR, that caused the conversion error. I am still trying to find a way to solve this issue, will keep updated once it’s found.
Monday, August 23, 2010
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment