Not the error log specifically, but you can open up the log. Its default location is C:\Documents and Settings\username\Application Data\Microsoft SQL Server Migration Assistant\a2ss\log\

The Upsizing Wizard in Access works well enough. To upsize to SQL 2005, you will need Access 2003 or higher (2002 may work, 2000 will certainly not). But...

Sounds good, thanks! Even knowing WHAT to ask is a big step forward, here.

No. As I said, I'm not very familiar with SSIS. My data flow consists of an Access OLE DB connection connected to the SQL OLE DB connection, for...

What I'm trying to do is streamline the process of refreshing the data in the SQL server from the Access source for a few weeks until production data is in...

Thanks again. Not all of the Access tables had identity columns - the SSMA_ROWID is an automatically-generated identity column that exists on the SQL server but not in Access....