Post reply

Executing DTS packages in a Batch file.

  • June 9, 2006 at 8:29 am

    #115455

    Hello,

     

    I designed a DTS package in Enterprise Manager, and I'd like to allow an end user to execute this package from a .bat file.  I've written the .bat file and it works on my machine, but for some reason it won't work on the end users machine.  Is there any way to get the .bat file to execute on his machine?  I've installed enterprise manager on his machine as well, but for some reason it doesn't work

     

    Thanks.

  • June 12, 2006 at 5:51 am

    #643043

    I think you're missing the whole ownership chain. I guess you could use the o/s  "run as"  to impersonate your service account. It's not really a route I'd recoomend though.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • June 12, 2006 at 6:56 am

    #643058

    dtsrun/dtexec will take switches for username and password...

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply