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 ...

  • 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

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy