Hi everyone , i have e little problem, in the fourth last months my aplication was running a SSIS package (Monthly) with no problems until this present month. this package have the mission to load a fact table, have nested querys, and is very simple one data flow task, with one ado.net source and one ado.net destination inside and usually insert 40000 new rows. But show me this error Information: 0x4004300A at CARGAR_FACT_PROD, SSIS.Pipeline: Validation phase is beginning. Information: 0x40043006 at CARGAR_FACT_PROD, SSIS.Pipeline: Prepare for Execute phase is beginning. Information: 0x40043007 at CARGAR_FACT_PROD, SSIS.Pipeline: Pre-Execute phase is beginning. Error: 0xC0047062 at CARGAR_FACT_PROD, FACT_Operaciones [1]: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter.PreExecute() at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPreExecute(IDTSManagedComponentWrapper100 wrapper) Error: 0xC004701A at CARGAR_FACT_PROD, SSIS.Pipeline: component "FACT_Operaciones" (1) failed the pre-execute phase and returned error code 0x80131904. Information: 0x4004300B at CARGAR_FACT_PROD, SSIS.Pipeline: "component "FACT_PROD" (827)" wrote 0 rows. Information: 0x40043009 at CARGAR_FACT_PROD, SSIS.Pipeline: Cleanup phase is beginning. Task failed: CARGAR_FACT_PROD Warning: 0x80019002 at 08_FACT_OperacionesFomento_TransToProd: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (2) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors. SSIS package "08_FACT_OperacionesFomento_TransToProd.dtsx" finished: Failure. I already has read it this topics http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/2f9f479e-88d5-4584-afa7-d8516f1d44fe , but i still getting the same error. I have refreshed the datasource Remapping the columns between source and destination Deleted the package. Build the package again. I have put the timeout over 100 .. But no results, and finally have tested the package on test DB instance and same error and i have another packages that load other fact tables with no problems Thanks in advance my friends pd: I am using sql server 2008 enterprise edition.

I've had difficulties with the ADO.Net Sources and Destinations. I notice your error shows you're connecting to a SQL Server. Would changing to OLE DB Sources and Destinations be possible? In my experience, they're more reliable... Talk to me now on