• Replies 7 replies
  • Subscribers 337 subscribers
  • Views 67 views
  • Users 0 members are here
Related

NOCOA Import error

Former Member
Former Member $organization

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

Parents
  • $organization

    I'd check to make sure all the columns in the source file are lined up correctly - including any possible blank columns at the end. If that's alright, you might try running a trace to find the procedures it running, then try running that in your test system (making sure to make the files being worked on available to the test db server.) That might get you to a more specific error where it would tell you exactly what columns are being problematic.

Reply
  • $organization

    I'd check to make sure all the columns in the source file are lined up correctly - including any possible blank columns at the end. If that's alright, you might try running a trace to find the procedures it running, then try running that in your test system (making sure to make the files being worked on available to the test db server.) That might get you to a more specific error where it would tell you exactly what columns are being problematic.

Children
No Data