Home Forums SQL Server 7,2000 T-SQL BCP error -Unable to open BCP host data-file RE: BCP error -Unable to open BCP host data-file

  • When you run bcp on your local machine C:\ is your local drive.

    When you run bcp on the server C:\ is a local drive on he server.

    Compare:

    "dir C:\" from command prompt and

    exec master.dbo.xp_cmdshell 'dir c:\'

    _____________
    Code for TallyGenerator