Home Forums SQL Server 2005 SQL Server 2005 General Discussion BCP Command out/queryout Issue. RE: BCP Command out/queryout Issue.

  • February 21, 2008 at 11:52 am

    #780812

    Shiv (2/21/2008)

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

    But today Iam getting a diferent error when i try queryout in QA

    Error = [Microsoft][SQL Native Client]Unable to open BCP host data-file

    Please let me know the solution for this error. Is this any thing related to the permissions?

    I am using SQL Server 2005 Management studio.

    (Do I need to set any settings in the configurations like that ? bcos, I am just runing this in my local machine now . Or Do I need to Install SQL Server Express Edition?)

    or is it some thing other than these settings ?

    Your help could be of great use.

    Thanks,

    The SQL Service login must be able to "see" the path for this to work. In other words, the login that the SQL Server logs in as must have the privs to see the directory.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)