Here is my problem. We have a few users who need to run a dts job at the end of the day to create the bank file. I have a stored procedure that does some prep work and then uses xp_cmdshell to create the file. The stored procedure is issued by an I/Q report.
It seems that we needed to make these users members of the domain admin group for them to be able to create this file.
What am I missing? How can I let users run DTS jobs without access to the server itself?
Any suggestions? Thanks, Barb