Right click on the job and do a Generate SQL Script. CLick the Preview button and look at the line for:

--Add the job

and take a look at the variable...

In my shop we monitor dts creation. Developers can create all the DTSs they want, but if they want to modify a package that they are not the owner...

Well, that's real helpful. What I want to know is how to determine if a table is needed or not? I don't want to create another code table...

I suggest using an application role for the vb apps...this allows the users to only access the db via the application. I'd revoke direct access to all objects except...

Thanks Frank and Remi! I appreciate the help.

You could just script out the existing logins and users and do a 'replace all' in Query Analyzer to replace OLDDOMAIN with NEWDOMAIN. Drop the existing logins and users...

Thanks dmbaker. I'd never used that disconnected edit before and it really is helpful. I was able to determine the failing step was an insert task so now...

Thanks for the tip about logging and the script. I forgot to mention we're running SQL 7.0 which does not allow dts package logging. Any other ideas?

We applied FullInstalVer = 2.80.1048.0 as it seemed to be the most recent, but after we applied it we found it wasn't the most recent, though it still resolved the...

We just ran into this same problem last week. Windows 2003 comes with MDAC 2.8. You need to apply a hotfix for 2.8. See article at http://support.microsoft.com/default.aspx?scid=kb;en-us;839801

After...