I am using SSIS 2008 R2 to migrate data from Orcale to SQL 2008 R2. when is execute paralle data during package exection i am getting follow error.
Source: ADO NET Destination  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. The
statement has been terminated. so, i changed the parallel to sequential data flow task execution in my package. it was working fine.
i wonder today that same issue is popping up on my screen.
what could be the issue?
can you please help me to resolve?
View Complete Post