Post reply

DTSRun utility and Security

  • June 9, 2008 at 4:36 pm

    #71616

    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

    #828845

    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