May 22, 2007 at 10:44 am
I'm having problems getting this DTS package to run in a stored procedure. All the data chugging is fine, but when I try to write to a log file on a different server as well as export a csv to a different server, I get permission errors, but only when executing my DTS from a sproc. I'm using the xp_cmdshell command in my sproc and it's calling the same exact DTSRun line that works flawlessly in the command line. I'm assuming that when running a DTS package through a sproc, different permissions are set, but I've changed the permissions on the folder on the other server to give full control to "everybody". I don't know how anyone could be getting left out. Has anyone had experience with running a DTS package in a sproc who could maybe help me?
May 24, 2007 at 8:23 am
Check out the response in http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=368359 Mr. Hamar provides a nice explanation of permission issues across servers that should help you.
Regards,
Matt
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply