Hey everyone,
Unfortunately, Naomi, I’m not answering your question about your BCP error importing orders. I’m adding my own.
All of a sudden, I’m getting an error similar to Naomi’s while attempting to EXPORT a file using the NCOA utility. Mine says:
SQLState = S1000, Native Error = 0
Error = [Microsoft][SQL Server Native Client 10.0]Unable to open BCP host data-file
Return value from stored procedure AP_BCP_FILE: -109
When I check the procedure, there is no info on what an error of type -109 is.
HALP!
Rey
--
A. Rey Pamatmat
Tessitura Manager
The Public Theater
425 Lafayette Street
New York, NY 10003
(212) 539-8739
RPamatmat@PublicTheater.org
Rey,
I had that error sometime ago doing data conversion. What I did to resolve it was create a blank text file in the output file path name whatever your export is named i.e. export.txt, ran the job again and it updated that file with the data I needed.
Thank you and have a great day!
Naomi Williams
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of A. Rey Pamatmat Sent: Tuesday, September 07, 2010 1:22 PM To: Naomi Williams Subject: [Tessitura Technical Forum] NCOA Export BCP Errors
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!