I have a DTS job that sends email via SMTP that executes every 10 minutes for every database on my SQL 2000 sp3, Windows 2000 sp2 production server. Lately, I am getting pop-up errors that read:
dtsrun.exe The application
failed to initialize properly (0x0000142). Click on OK to terminate the
application."
This job used to work fine, but recently i added 10 more database to my production environment. I am wondering if there is a concurrency issue for DTS that is causing this issue since it worked fine with only 5 databases.
Has anyone seen these issues before? My KB search came up with nothing.