32 bit I think, and I couldn't find the error code either! It runs perfectly in BIDS.

I'll try another example (that runs OK in BIDS) tomorrow to make...

Sorry, I left off the important bit, I get a different error now when I add the extra line "Retrieving the file name for a component failed with error code...

I've just returned to this problem having done a little more testing and am becoming suspicious of the Excel.Application object. I have since migrated some other [SSIS] packages containing ActiveX...

The package is on a local drive and both it and the folder it's in are shared by everybody. I don't know about the SQL Agent, all I've done is...