Error in SSIS package after upgrade to SP2 release

I upgraded to SQL Server 2005 SP2 release today. I had been working with 9.00.1399. I had developed few packages in the older version which were getting invoked through the asp web application locally and it was working fine.

Today I upgraded to SQL server 2005 3042 version.
Now the same packages are not working when invoked through the web application. But it works fine stand alone. All errors refer to connection problem.

I need to resolve this urgently. Can anyone help me please?

Errors -

"SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.\r\nAn OLE DB record is available. Source: \"Microsoft JET Database Engine\" Hresult: 0x80004005 Description: \"The Microsoft Jet database engine cannot open the file ''. It is already opened exclusively by another user, or you need permission to view its data.\".\r\n"

SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.

I have seen that error from time to time. it indicates that the excel file where the connection manager is pointing to is open by other application/process. I read a Phil's suggestions to use a third party to monitor and detect who is actually holding the file, but I don't remember the name.

In the mean time, try closing all applications that may be 'holding the file' and run the package again.

|||Hi,

The error appears due to the upgrade to the SP2 version.

I restarted my system. No other process accessing the excel.
But still the same error.
This functionality used to work fine with the older version of SQL.