June 25, 2009 at 7:54 pm
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
Log in to the server using Terminal Services and run it there ...
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
June 28, 2009 at 5:07 pm
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
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
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