Post reply

client doing work in ssis package residing on server

  • June 25, 2009 at 7:54 pm

    #223083

    hi folks,

    I notice when you login to integration services from a client machine and run a package the work of the package seems to get done on the client. Is there a way to change this so that the server takes the hit.

    thanks

  • June 25, 2009 at 8:35 pm

    #1015737

    Log in to the server using Terminal Services and run it there ...

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • June 28, 2009 at 5:07 pm

    #1016568

    Is that the only way? I would like to keep the developers off the server if I could help it.

  • June 29, 2009 at 7:34 am

    #1016813

    You can use a SQL Agent job to execute the SSIS package. If you can't schedule it, then your developers would need to be able to execute sp_start_job.

  • June 30, 2009 at 9:30 am

    #1017671

    Remote Desktop and SQL Agent are the only "good" ways to do it, you could use DTEXEC through xp_cmdshell, or for build a sproc that does it for them so they don't have as much access.

    CEWII

Viewing 5 posts - 1 through 4 (of 4 total)

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