The job ran but did not finish. Connections worked. When I re-run the job, it ran completely w/o time out expired error. I am not sure what is going on, anything will help! Microsoft (R) SQL Server Execute Package Utility Version 10.0.2531.0 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 5:30:00 AM Error: 2011-08-22 05:31:08.54 Code: 0xC020844B Source: Data Flow Task ADO NET Destination [763] Description: An exception has occurred during data insertion, the message returned from the provider is: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. End Error Error: 2011-08-22 05:31:08.58 Code: 0xC0047022 Source: Data Flow Task SSIS.Pipeline Description: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "ADO NET Destination" (763) failed with error code 0xC020844B while processing input "ADO NET Destination Input" (766). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 5:30:00 AM Finished: 5:31:08 AM Elapsed: 67.719 seconds

The cause is a lengthy execution. May need to revise how to improve, the immediate fix is in increasing the default timeout of the ADO connection. This is how: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/44e77439-1dfa-4dfe-aff2-8c52e59314ae/Arthur My Blog

Thanks! I will look in to this.