Results 1 to 2 of 2

Thread: Packages in schedules

  1. #1
    Join Date
    Nov 2002
    Posts
    261

    Packages in schedules

    In sql 2000 if you created a dts package and then scheduled it life was good. however if you went back and changed the dts package and saved it the job that runs the DTS would run the original package, not the changed one. In sql 2005 I created a maintenance package to dbcc all db's and optimize all db's. I went in and noticed that 2 new db's I had created were not included in the "generate tsql from the package" I did a refresh and now they are included. My question is, I saved my changes, now under sql 2005 will the new package be run or the original version?

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Should run new version. By the way, sql2k runs new version as well. At least on my servers.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •