BCP import help

  • I have no trouble running this export command:

    bcp database.dbo.tablenameA out test.txt -S servername -T -c

    A file with the requested data is written to the C:\ drive of my SQL server. But, I get the error "Unable to open BCP host data-file" when I run this import command:

    bcp database.dbo.tablenameB in test.txt -S servername -T -c

    I imagine the issue has to do with file permissions, but I don't know which account I need to grant access to in the case of the "-T" aka trusted account.

  • I gave "everyone" fullcontrol and that worked.

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

You must be logged in to reply to this topic. Login to reply