Post reply

scheduling and executing the dts packages

  • January 20, 2011 at 5:46 am

    #233445

    Hi,

    could anybody tell me how to schedule the dts package and how to execute the dts package....

    Thanks

  • January 20, 2011 at 5:56 am

    #1275832

    You've posted in an Integration Services forum. Please will you confirm whether you are referring to DTS packages or SSIS packages?

    Thanks

    John

  • January 20, 2011 at 6:01 am

    #1275837

    if you are talikng about the ssis packages you can execute and schedule it using sql job agent.

    The below URL might help

    http://www.sql-server-performance.com/articles/biz/Scheduling_a_SSIS_Package_in_SQL_Server_Agent_p1.aspx

  • January 21, 2011 at 1:55 am

    #1276417

    Iam talking about dts packages only...

    How to scheduling (jobs)and executing the dts pakages.....i will be happy if anybody reply for this....

    Thanks

  • January 21, 2011 at 2:27 am

    #1276425

    Whenever u save the DTS package as SQL Server a job gets created automatically for it. Once that job gets created then u can schedule it as per your convenience.To schedule a job just Right Click on it and select Properties, u shall be able to view the schedule option.

    Hope this helps u.

    Satnam

  • January 21, 2011 at 2:28 am

    #1276426

    Whenever u save the DTS package as SQL Server a job gets created automatically for it. Once that job gets created then u can schedule it as per your convenience.To schedule a job just Right Click on it and select Properties, u shall be able to view the schedule option.

    Hope this helps u.

    Satnam

Viewing 6 posts - 1 through 5 (of 5 total)

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