Another thing to point out is that a job is based on the underlying DTS, and the properties of the DTS might specify that it "fail on first error".

See:  Package|Properties|Logging

Yes, you may want to look at...

sp_helpuser

sp_helplogins

exec sp_MSforeachdb @command1 = '?..sp_helprotect'

Make sure that you're using the full UNC path -- it may not be mapped on the server.

For example:

//servername/path/filename.ext

If you're migrating to a new server and use DSNs, make sure that they are updated with the new server name, or if the connection string is hard-coded, then change...

Make sure that the path has not changed by your LAN guys.  This sometimes happens to us without any kind of notification from them.  Not sure why they do this...

Is it possible to set up a trace through Profiler to record the error and additional information desired?

I have found the following books to be very helpful...

Microsoft SQL Server 2000 Administrator's Pocket Consultant (Microsoft Press)

The...

I agree.  We have nightly extracts that pull from DB2 and the time necessary to extract the same data really varies.  Some nights it can take as little as 1.5...

Don't forget to put the database in single user mode first.

And run "update statistics" after you're finished.

Do something like...

exec sp_dboption 'your_database_name', 'single user', true

exec sp_detach_db 'your_database_name'

-------------------------------------------------------------

-- MANUALLY COPY/PASTE .MDF/.LDF FILES...

I've noticed that at times, if I right-click on the DTS package and choose "Schedule", I have to hit the refresh button after I navigate to the Jobs section to...

We're on IBM and it seems that every time a new fixpak is installed, a new bug is introduced, or an old bug resurfaces.  Kinda frustrating!!!

I agree with David.  If you're going to convert the Access queries to be SQL Server specific to allow for pass-thru queries, you might as well simply take this SQL...

That's what we use with the IBM DB2 client components installed on the server.  Seems like I did have a problem using the "IBM DB2 ODBC Driver", but when I...

Quote from http://www.sqldts.com/default.aspx?208

... one drawback to using Visual Basic is that it is apartment threaded and DTS is free threaded. This can cause exception access violations. The simple way...