Re: SSIS Deployment

Pravin wrote: 
Ilya,

Wow that would be really useful. So my SQL Server will be loaded on a SERVER machine (remote machine)...and C# application will run on client machine...which will call DTEXEC.EXE residing on server machine. Cool!

Just like DTS, SSIS packages are executed on the machine which calls them, the host process, so the package executes upon the machine which DTEXEC is running. If you can invoke a process on a remote machine, then this will work, rather than just load an exe over the network and run it locally.


How to do this? Is it just include the path of DTEXEC.EXE (residing on remote machine) in system variable "path" of client machine?

Do we need to do anything else? Thanks.



--
Darren
http://www.sqldts.com
http://www.sqlis.com
.

Relevant Pages

  • Re: Terminal Server and DNS
    ... What happens if you run "netstat -ano" on the server machine? ... Jeffrey Randow (Windows Networking & Smart Display MVP) ... Remote Networking Technology Support Site - ... >>you connecting, ...
    (microsoft.public.windows.server.networking)
  • Re: Interesting Socket error when contacting .net remote server
    ... I have a .net remote server application (console app hosting a .net remote ... I also have a windows service on another machine that creates the ... Now the server machine gets rebooted often and so the windows ... service on the client machine has retry logic (by catching socket ...
    (microsoft.public.dotnet.framework.remoting)
  • Re: ServiceController with remote services
    ... I would rather not use an Admin account if possible. ... missing permissions are, ... impersonated by the remote client application, or it will be the user ... to the remote server machine that has been established on the remote server ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: No DISPLAY set in -X Tunneling
    ... > display). ... The X forwarding allows X clients running on the SSH server to ... connection to the X11 display is automatically forwarded to the remote side ... creates a ``proxy'' X server on the server machine for forwarding the ...
    (comp.security.ssh)