Forum Replies Created

Viewing 9 posts - 1 through 9 (of 9 total)

  • RE: BCP Command out/queryout Issue.

    Jeff Moden (2/22/2008)


    1. I just have modified my select statement a bit like iam just taking all now

    means...

    bcp "Select * from CurveTempDB.dbo.tLoanVectors where cusip='86359B6G1' " queryout C:\Sample.txt -T -c

    for which...

  • RE: BCP Command out/queryout Issue.

    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...

  • RE: BCP Command out/queryout Issue.

    Jeff Moden (2/22/2008)


    Ok... first, we have to determine precisely what the problem is... correct identification of the problem will be 90% of the solution....

    1. Are you still using this...

  • RE: BCP Command out/queryout Issue.

    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...

  • RE: BCP Command out/queryout Issue.

    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...

  • RE: BCP Command out/queryout Issue.

    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...

  • RE: where caluse help please.

    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...

  • RE: where caluse help please.

    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...

  • RE: where caluse help please.

    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),...

Viewing 9 posts - 1 through 9 (of 9 total)