June 9, 2008 at 4:36 pm
Greetings,
I've got a DTSRun batch file set up to allow a non-admin to run a DTS package at his leisure. It works great for me, but not for him. We are both set up with Windows accounts that are in the db_owner role for the database. The SQL user is set up in the Process Administrator server role and the package owner is a service account that is in the sys admin server role.
Here is the text of from the batch file.
dtsrun /S SERVER /U AP_Report /P AP_Report /N UploadPackage
Anyone have a suggestion of why he isn't able to run this?
Thanks,
Tim
June 13, 2008 at 4:14 pm
I got a bit more info now. THe end user is getting an error saying he doesn't have DTSRun. Even when I put in the full path of the DTSRun.exe and place the batch file on a share on the SQL server. It works just find for me, is that because I have SQL components on my laptop, but this guy doesn't?
Thanks,
Tim
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply