DTS wizard error 80040154 for SQL Server 2005 Express

i'm using the dts wizard that is provided via the additional tools for sql server 2005 express. i can connect to my server, select a db and select the table/view that i would like to export. likewise i can configure the target for the export to access, another sql server db, or xl. however - upon executing i get the following in the report when it fails.

Operation stopped...

- Initializing Data Flow Task (Success)

- Initializing Connections (Success)

- Setting SQL Command (Success)

- Setting Source Connection (Success)

- Setting Destination Connection (Success)

- Validating (Success)

- Prepare for Execute (Stopped)

- Pre-execute (Stopped)

- Executing (Error)
Messages
Error 0xc002f210: Preparation SQL Task: Executing the query "" failed with the 
 following error: "Retrieving the COM class factory for component with 
 CLSID {7816B7A3-CD60-4539-BD38-C35AFC61F200} failed due to the following 
 error: 80040154.". Possible failure reasons: Problems with the query, "ResultSet"
 property not set correctly, parameters not set correctly, or connection not
 established correctly.
 (SQL Server Import and Export Wizard)


- Copying to `dt_location` (Stopped)

- Post-execute (Stopped)

- Cleanup (Stopped)

i have tried both sql native and oledb for sql server. when using ole i can export a table/view to txt. this is an ok soln but i really need to be able to use the dts for exporting multiple tables to an access db periodically.

i've spent a good amt of time reading every post that i can find relating to this topic and error number.

any help is greatly appreciated!!!

thanks, alison