BCP usage

Question

BCP usage

Viewing 3 posts - 16 through 17 (of 17 total)

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

Michael L John One Orange Chip Points: 27059 More actions · Answer 1

Raghavender Chavva - Tuesday, March 12, 2019 6:33 AM
Can you please help me here.
bcp.exe [dbo].Tablename in "D:\ABC\Extract.dat" -c -t\| -r\n -d DSP -T -S Instancename
When I am executing this bcp command I am receiving below error:
The system cannot find the path specified.
Files are already placed and the account which is executing the BCP command has admin privilages on that box.
Not sure where I am missing.

The service account that is running SQL Server needs to have access to that folder. Your permissions do not matter in this case.

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/

ZZartin SSC-Dedicated Points: 30920 More actions · Answer 2

Michael L John - Tuesday, March 12, 2019 8:34 AM
Raghavender Chavva - Tuesday, March 12, 2019 6:33 AM
Can you please help me here.
bcp.exe [dbo].Tablename in "D:\ABC\Extract.dat" -c -t\| -r\n -d DSP -T -S Instancename
When I am executing this bcp command I am receiving below error:
The system cannot find the path specified.
Files are already placed and the account which is executing the BCP command has admin privilages on that box.
Not sure where I am missing.
The service account that is running SQL Server needs to have access to that folder. Your permissions do not matter in this case.

The paths are relative to the account/computer running the bcp command.

Raghavender Chavva SSCrazy Eights Points: 8669 More actions · Answer 3

Michael L John - Tuesday, March 12, 2019 8:34 AM
Raghavender Chavva - Tuesday, March 12, 2019 6:33 AM
Can you please help me here.
bcp.exe [dbo].Tablename in "D:\ABC\Extract.dat" -c -t\| -r\n -d DSP -T -S Instancename
When I am executing this bcp command I am receiving below error:
The system cannot find the path specified.
Files are already placed and the account which is executing the BCP command has admin privilages on that box.
Not sure where I am missing.
The service account that is running SQL Server needs to have access to that folder. Your permissions do not matter in this case.

Services are running on local service accounts. So I have given full access to everyone. But still same error.
FYI: This box is dedicated to our testing, so we can modify anything.

Thank You.

Regards,
Raghavender Chavva