Thank you Old Hand.. the article is very helpful. DTSER_FAILURE issue is resolved after reading your solution ( article)... You are very helpful!!!!!!:-)

-- Selected 32 BIT Option in SQL Server agent job under one of the tab while establishing a connection from SQL 2008 to SQL 2005

-- Job ran succesfully