Post reply

MSDE and DTS

  • July 26, 2006 at 2:50 am

    #92142

    I have SQL server with DTS jobs working fine on it. Now, it is required to configure same jobs at some other locations where only MSDE will be present. What could be the simpleset way to take existing .dts files and schedule them as job at MSDE. I have found some discussion on dtsrun.exe but it didnt work OR may be I am missing some steps.

  • July 27, 2006 at 2:15 am

    #651806

    You can use DTSRun.exe to execute on the MSDE server, and use the Windows Scheduler to schedule the jobs. MSDE does not support SQL Server Agent Jobs.

    Andy

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

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