SQL Server Performance

Schedule DTS package in Windows Scheduler

Discussion in 'SQL Server DTS-Related Questions' started by suneelmehra, Jun 5, 2006.

  1. suneelmehra New Member

    Hi,
    Can anyone please let me know, How do we schedule a DTS package in Windows Scheduler.

    Thanks,
    Suneel
    suneelmehra, Jun 5, 2006
    #2

  2. smy New Member

    create a batch file to run the dts package:

    type in the following in the notepad:
    dtsrun /F "D:mydtspackage.dts" /E


    where /E is for windows authentication
    "D:mydtspackage.dts" is your DTS package location

    Save the notepad at the extension of .bat
    Run the windows scheduler and schedule it to execute this file.
    smy, Jun 5, 2006
    #2

  3. satya Moderator

    Use AT.EXE from command prompt for windows scheduler and can we know why you want to do this via WS.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
    satya, Jun 6, 2006
    #2

  4. suneelmehra New Member

    Actually, On our server SQL Agent is not running and we don't want to run for scheule the DTS job.
    Satya,
    We already have some schedule DTS on WS. But they are not setup as SMY said. I'll try ur option and let know.
    suneelmehra, Jun 9, 2006
    #2

  5. satya Moderator

    Any reason why SQLagent is not running or what kind of problems occurred when trying to start?

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
    satya, Jun 9, 2006
    #2

  6. suneelmehra New Member

    No specific reason. Could be start any time. But as per requirement we do not want to start.
    suneelmehra, Jun 12, 2006
    #2

Share This Page