Invalid object name error while executing SSIS package ?

See more:

SSIS

Hi,

On executing a SSIS package, I am getting the below error : "Executing the query 'SP_ABC' failed with the following error: 'invalid object name 'Tablename_tmp'. Possible failure reasons: Problems with the query. 'Result set' property not set correctly, parameters not set correctly or connection not established corectly. "

'SP_ABC' - stored procedure used

'Tablename_tmp' - temprorary table which is not refered in the stored procedure.

The object name('Tablename_tmp') refered in the error is not referred in the related stored procedure and not present in the whole database.

I could not able to sort out this issue. Please help.

regards,
Dhivya