Greetings,
I am trying to get this utility to do something, anything, for me at this point. I have been trying to get a simple test import to work (I exported 2 orders from one performance via the export utility and am using that same tab delimited .txt file to import into another performance... same MOS, same price type, customer_no already exists in our db. Payment method is cash and accessible). The permissions on the folder are good, I am running it under an administrator user group, I have verified permissions on everything (famous last words). What I get is a barely 2 page review report, and the error message just stops in the Import Process Log portion with 'Error 0, Severity 0, State 0, Procedure, Line 0'.... and no other error message. I've traced the procedure and I see that there are tons of meaningful error messages in the code. I've re-watched the webinar. I've even said 'pretty, please!'.
Anyone ever seen this type of non-error with Order Import? I've opened a help ticket, but was hoping there might be someone out here who had a quicker answer.
Thank you, thank you!
Nancy
Thanks everyone! The solicitor was my first problem and my second was not having a file set up explicitly in the error field. And then my 3rd problem (I think) was my bcp trusted connection was messed up... we've recently upgraded our production cluster to Windows 2008 and SQL Server 2008 R2, so we were on a temp server for awhile and in the move back and forth I think our proxy user got disassociated from the proxy. At least my bcp OUTs were okay (at least extractions were) but our bcp INs were not. At least that's as far as I've gotten investigating it (and frankly as far as I'm going because it's working now and I need to move on).
Thank you again for your thoughts, they were very helpful!