Automation of DTS package

  • Hi ,

    I want to run DTS package automatically on weekly basis to update a database. Can anyone help me out.

  • Create a job and schedule it. you need run the sql agent up and running..

    Warm Regards,
    Neel aka Vijay.

  • right click on dts package and select 'schedule package'. this creates a sqlagent job which runs the package.

    ---------------------------------------------------------------------

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

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