VERIFIED SOLUTION i

How to increase connection time-out for OLE DB connection made on SQL Server in Sagent Data Flow

All Supported DFS builds - As of current date
One needs to create with a DWORD registry key “ConnectTimeout” [value in seconds] at HKEY_LOCAL_MACHINE\SOFTWARE\Sagent\DataMart\RW\Customize\OLE DB\Microsoft OLE DB Provider for SQL Server.

This will increase the time-out for OLE DB connection made to sever to the value specified.
 
In the attached screenshot, I have increased this value to 60 seconds.
 
Depending upon your installation in 64 bit OS, you might need to make this change on Wow6432node as well.
UPDATED:  November 7, 2017