SSIS Package timouts - how to prevent
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
I checked the Connection Manager and both Connection Timeout and General Timeout are set to 0
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.