Task created to transfer tables from SQL Server 2008 on another server/instance to SQL Server 2008R2 instance. When executing manually alll works. When scheduling the task through SQL Agent it fails. No error message supplied except for 'look in the log' and the log has no information.

This has to do with the account used to run this package. Seems you used the default [Agent profile] not a proxy for it, thus the package cannot run as expected. How to Schedule and Run a SSIS package ( DTS ) Job in SQL Server 2005: http://www.codeproject.com/KB/aspnet/Schedule__Run__SSIS__DTS.aspxArthur My Blog

Does SQL Agent service account has enough permissions on both servers? Please look in windows event logs for errorshttp://uk.linkedin.com/in/ramjaddu

Thanks you both for your replies..... it is all working now using the right account to execute the jobs!!

Could you please mark your question as being answeredJeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA, MCSD, MCAD

The following page deals with setting up SSIS package to run under a proxy account: How to: Automate SSIS Package Execution by Using the SQL Server Agent (SQL Server Video) The page above has a number of How To (non-video) links as well. Kalman Toth, SQL Server & BI Training; SQL 2008 GRAND SLAM