tthompsonsql
asked on
BCP Invalid Character value for cast specification error
I am getting the 'Invalid Character value for Cast Specification' error when I try to bcp a text file in. I am pretty certain that its because of the '/' in the date. Is there a command that I can run to eliminate those from the text doc and replace with another character that will copy?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
so is the fix not for your case?
pls, post some sample code where you have /
pls, post some sample code where you have /
ASKER
I'm going to replace the '/' with '-' and see if your above solution will work then. thanks.
ASKER