Validation error on Chap19 Sample, CaseStudy_Load package

cJeffreywang · February 15th, 2011, 05:38 PM

Validation error. Data Flow ACH Detail Data Load OLE DB Save Destination [244]: Columns "RAWINVOICENBR" and "RawInvoiceNbr" cannot convert between unicode and non-unicode string data types. CaseStudy_Load.dtsx 0 0

Questions:
1. Why 2 columns "RAWINVOICENBR" and "EawInvoiceNbr"?
2. There is a Derived column tranformation for RawInvoiceNbr:
RAWINVOICENBR <add as new column> DESC string [DT_STR] 50 1252 (ANSI - Latin I). Something wrong with above property or the property is different for SQL Server 2008R2?
3. Any suggestion to fix the problem for the xml or xsd source file? Thanks.

cJeffreywang · February 18th, 2011, 01:21 PM

I have had the declaration, <?xml version="1.0" ?> on my source xml file
Do I need to change to <?xml version="1.0" encoding="UTF-16"?>??