title: Redshift ODBC Errors
body: <p>I am using Redshift ODBC 32-bit drivers to pull data in SQL-2016 via SSIS 2015 ODBC Connection. I have huge amount of data to be loaded from Redshift. I loaded about top 10000000 reocords in 21 mins. </p>
  
  <p>However, my historical table has 260636061 records. If I run package to load all data, then it runs for some time and throws the following error - </p>
  
  <p><strong>[ODBC Source [2]] Error: Open Database Connectivity (ODBC) error occurred. state: 'HY000'. Native Error Code: 30. [Amazon][RedShift ODBC] (30) Error occurred while trying to execute a query: server closed the connection unexpectedly.This probably means the server terminated abnormallybefore or while processing the request.</strong></p>
  
  <p><strong>[ODBC Source [2]] Error: Open Database Connectivity (ODBC) error occurred. state: 'HY001'. Native Error Code: 10010.[Amazon][ODBC] (10010) Memory allocation error: std::bad_alloc exception is caught.</strong></p>
  
  <p><strong>[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.  The PrimeOutput method on ODBC Source returned error code 0x80004005.  The component returned a failure code when the pipeline engine called PrimeOutput().  The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.  There may be error messages posted before this with more information about the failure.</strong></p>
  
  <p>Any idea how to resolve this issue? OR shouldn't we pull this much data at once from SSIS? </p>
  
  <p>Thanks </p>