Post reply

SQL 2000 DTS Package Scheduling in SQL 2005

  • November 10, 2008 at 9:08 am

    #154905

    Hi all,

    Pretty new to this forum so go easy.... apologises if this has been answered before but my searching has not been producing what i want.

    bascially i have some DTS packages built in SQL 2000 that I need to use in SQL 2005 as I don't currently have time to migrate etc...

    I have managed to install the DTS 2000 package and check them out, but need to schedule.

    What is the best method ?

    I have found the following -

    1. Create SSIS Package with the Execute DTS 2000 item in for each one and schedule

    2. Use T-SQL to run the dts package using dtsrun/dtsexec

    3. Use dos commands and create schedules in Windows Task Scheduler.

    any thoughts are welcome and thanks for your time

    Danny

  • November 12, 2008 at 11:33 am

    #897699

    My preference is to create a scheduled SQL Agent job and a DTSRUN command in a job step (CmdExec type), just like you did it in SQL 2000.

    Greg

  • November 12, 2008 at 12:20 pm

    #897720

    Thanks for the reply Greg...

    Indeed that appears to be the way forward 🙂

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

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