Validation error on Chap19 Sample, CaseStudy_Load package
Validation error. Data Flow ACH Detail Data Load OLE DB Save Destination : Columns "RAWINVOICENBR" and "RawInvoiceNbr" cannot convert between unicode and non-unicode string data types. CaseStudy_Load.dtsx 0 0
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.
C. Jeffrey Wang