I use a bcp out command to write data from a table into a text file. I execute the procedure from a dts package and the package uses windows authentication to connect to the database.
For the bcp command i provide the db server login and password. but the bcp command fails even though the windows login account has write access to the target folder.
but when i provide write access to everyone to the particular folder, the text file is successfully saved.
Which user id does SQL Server use when it tries to write the text file into the folder.
Are there any alternatives to providing write access to everyone to the folder.
Thanksz