If you have an OLE DB Source within a Data Flow in your SSIS package, and you click on the Preview button to get a sample (max of 200 rows) of the data returned by the statement you have configured, and the server takes more than 30 seconds to return
Read More...
