Hi all,
This is the first time I have been through the NCOA process so not sure what exactly the following error message is refering to:
Error = [Microsoft][SQL Server Native Client 10.0]Invalid character value for cast specification
This appears in the import report after impotrting to TW_NCOA_INCOMING where everything looks totally fine and ready to process.
I found some like this online, however the explanations didn't make sense to the situation. Any pointers woudl be great.
Thanks!
Tash
That invalid character value for cast specification error almost always points to a formatting issue (as Brian mentioned). Check for hidden characters, such as a return/space/tab, and that all of the columns are in the file (and in the correct order).