Run DTS Package from Command Line? Possible?

  • How does one run a dts package from the command line? We have a few packages not running from the SQL agent, and our app dev on call folks are not allowed to touch production packages, putting a batch file in between them and the package fixes this. So how do I run a batch file via CLI?

  • create a batch using the exec utility.

    http://msdn.microsoft.com/en-us/library/ms138023.aspx

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

Viewing 2 posts - 1 through 1 (of 1 total)

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