Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  job executes, package step doesn't

Author  Topic  cronid Starting Member 26 Posts Posted - 2006-08-05 : 14:25:15 I have a job which executes a driver package, which sequentially executes 10 packages to load our daily tables into history tables. I modified the 7th and 8th packages to add extra columns and saved them as pkg7_new & pkg8_new. I saved the original packages as pkg7_old & pkg8_old, deleted the original packages and saved the _new ones with the original names. The new packages worked just fine when I executed them individually but they failed when the job next ran. The problem was that the job was looking for the original package identifier associated with the pkg7 & pkg8 names but I'd deleted those versions. So I went into the driver package and refreshed pkg7 & pkg8 within it. Voila - the job did not fail the following day. But ... pkg7 & pkg8 are not loading the daily data!? When I go into the driver package and manually execute pkg7 & pkg8, I get the msgbox, 'task waiting completion ... switch to or cancel'. When I pick switch to, the package successfully executes and does load the data. Does anyone know what the problem is? Since the driver package executes at 5:45 AM and pkg7 & pkg8 impact subsequent jobs, manual intervention is not an option. Den