Viewing 9 posts - 1 through 9 (of 9 total)
Jeff Moden (2/22/2008)
means...
bcp "Select * from CurveTempDB.dbo.tLoanVectors where cusip='86359B6G1' " queryout C:\Sample.txt -T -c
for which...
February 22, 2008 at 8:20 am
Phillip Cox (2/22/2008)
Hey,Have you checked permissions on file system to ensure you can create the file?
Try creating a sub-directory and then running utility (e.g. c:\test\sample.txt)
Thanks,
Phillip Cox
Philip,
FYI
I just tested it...
February 22, 2008 at 6:20 am
Jeff Moden (2/22/2008)
1. Are you still using this...
February 22, 2008 at 5:48 am
Jeff,
Please let me know the remedy here.. Now that I got to know that I should give the permissions so that sql server should be able to see/recognize the path...
February 22, 2008 at 3:33 am
Ok,
I have given that direction as parameter bcos i want use it like a condition there. That's not problem I can just keep 'queryout' there directly instead of direction as...
February 21, 2008 at 8:59 am
Hi
I am using sql server 2005 and the database is my is my own database. I think this is clear.
we can try this any other data base that...
February 21, 2008 at 12:49 am
Hi
Iam using sql server 2005 . I just want to know like why am getting that
An error occurred while processing the command line error
on giving the 'out' in...
February 20, 2008 at 11:57 am
Hello Grant,
actually now iam getting a diff error while executing the same in query analyzer and taking queryout am getting error as ...
Copy direction must be either 'in', 'out' or...
February 20, 2008 at 9:04 am
Hi Grant,
Actualy, i was trying some thing where iam doing some bcp command operation.
Here is actual Question...Can you please let me know the Answer
ALTER Procedure BCP_Text_File
(
@table varchar(100),
@Cusip varchar(100),...
February 20, 2008 at 7:32 am
Viewing 9 posts - 1 through 9 (of 9 total)