If you are using multiple processors and thirdparty drivers, you might have to check the execute on main thread checkbox on workflow properties box in your package.

Books by Ralph Kimball--The Data warehouse toolkit and the Data warehouse lifecycle toolkit are excellent.

well i finally got the problem jobs to run. Microsoft Knowledge Base Article 318819 seems to have done the trick . well see if this got it. But you have...

Well i tried to rebuild the sqlserver registry entries i got this error

sqldumper.exe entry point not found

The procedure entry point mindumpwritedump could not be located in the dynamic link library...

Yes the server name is the same. I scripted out the jobs and recreated them, still with no luck. The new server is using hyperthreading but i dont think that...

it seems the offending jobs have certain packages that stop the job. when i go into dts design view, the packages seem to run and all the tasks will complete...

Only certain jobs will not run manually or by schedule. Some jobs will run fine.The packages will run. Although sometimes the done box does not come up, when i am...

we will have three db systems soon(oraclem,sql and informix. I was looking for something that would work in all three. Im not sure that rapid sql works with informix yet....

Well i found out that my password on the server had expired. this Wish they would have given a error for that. Everything seems to be working now

2 days and no errors...yet. I think updating the mdac worked. I hope i havent just jinxed myself 🙂

I have reinstalled the lastest mdac. I will see if this works.

thank you

Mark

Sounds like a bad network connection. Do you ahve any other network issues with other apps?

Steve Jones

steve@dkranch.net

Steve, I have talked to IT and they are having no other problems....