i've run into a problem with running a dts job that imports an access db
into sql on same win 2003 server. the database has no relationships and has
worked fine until i recently added a new field in a table in access.

crazy as it may sound, the dts job moves every field over fine except the
new field. i tested by creating a new table altogether and it transforms
fine.

there is nothing special about the data type, etc. it's just another integer
field like other existing fields.

Where can I look in a log for a detailed description of a job? is it from
inside QA?

I should mention that my dts job is dropping and recreating each table in
sql 2000.