I have an SSIS package I built to transfer data from one SQL Server table to another. I have about 8 mln records that needs to be transferred. The package runs fine for a while but eventually times out before it reaches 8 mln records. Is there any way to prevent the timeouts?
I checked the Connection Manager and both Connection Timeout and General Timeout are set to 0