Post reply

Kick off a DTS package from a scheduled Job

  • November 14, 2006 at 12:05 pm

    #174950

    Is it possible to kick off a DTS package from a scheduled job? If so how?

    Thanks...Nali

  • November 14, 2006 at 1:28 pm

    #671760

    Right Click on the Package, and click schedule, just follow the screens and schedule your job

  • November 14, 2006 at 8:12 pm

    #671825

    Have a look at DTSRun in books online. It describes how to run DTS packages and the various switches you need. Using this information, you can create a SQL Agent job to run your package.

    In its simplest form, the command will look something like

    DTSRUN /E /S servername /N "DTS Package Name"

    The "servername" is the name of the server where the package is stored (assuming that the file is stored in SQL Server.

    Cheers

    Stephen

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

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