Posted on: 2/13/2007 12:17:05 PM | Views : 780

I am having trouble with BCP. I get the same error with xp_cmdshell as I do with entering bcp as a DOS command. I have checked and rechecked the file names and permissions and even restart the PC.Does BCP even work when SQL Server 2005 Express on a PC?declare @sql varchar(8000)select @sql = 'bcp SYMITAR..ACCOUNT in C:\test\EXTRACT.ACCOUNT -T -f C:\test\ACCOUNT.FMT -S'+@@servernameexec SYMITAR..xp_cmdshell @sqlGO Volume in drive C has no label. Volume Serial Number is 08E5-2414 Directory of C:\test02/13/2007 08:44 AM <DIR> .02/13/2007 08:44 AM <DIR> ..08/31/2006 09:11 AM 27,503,161 EXTRACT.ACCOUNT08/31/2006 09:12 AM 6,879 FMT.ACCOUNT02/07/2007 08:46 AM 220 ACCTTYPE.FMT02/13/2007 08:44 AM 0 filelisting.txt02/07/2007 08:33 AM 220 ACCTTYPE.xml 5 File(s) 27,510,480 bytes ...

Go to the complete details ...