starting a pkg with task scheduler from a server without dtexec

Hi.  I want to use task scheduler on an initiating server to kick off a pkg.  

My pkg is stored in the ssis catalog on another server. 

How can I set up that kind of plumbing if there is no sql software on the initiating server? ie kick off a sql item from a non sql server?

April 20th, 2015 5:19pm

Run the package as a remote SQL Agent job with sp_start_job <job_name>

There is a blog post dedicated to this subject: http://blogs.technet.com/b/reeds/archive/2006/09/22/how-to-remotely-execute-an-ssis-package.aspx

Free Windows Admin Tool Kit Click here and download it now
April 20th, 2015 8:02pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics