aaa121
SSCertifiable
Points: 5902
More actions
March 5, 2007 at 1:43 pm
#177107
Hi All,
When running the command below I get the following error. I cannot see a problem. Can anyone help?
bcp FileImportDB
..Exam in "c:\FileImportPractice\ExamImportFile.txt" -T -c
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '.'.
MohammedU
SSCoach
Points: 19644
March 5, 2007 at 10:51 pm
#693244
I think you are running bcp command in query window...
bcp command is command line utility, if you want to run in query window you have call through xp_cmdshell command...
exec xp_cmdshell 'bcp.....'
MohammedUMicrosoft SQL Server MVP
March 6, 2007 at 10:59 am
#693385
That will be the answer! Ha, thanks for that.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply