title: SQLServer SSIS Error connecting to AS400
body: <p>I made a data source with this propierties:</p>
  
  <ol>
  <li>Provider "Native OLE DB\IBM DB" for i5/OS IBMDA400 OLE DB Provider",</li>
  <li>User id and the password are filled.</li>
  <li>Persist Security is true.</li>
  <li>Catalog library list is filled.</li>
  </ol>
  
  <p>I made the connection manager based on the data source, I made a OLE DB Source with this Connection manager, It show me the list of the tables name, I choose the table I need But when I click OK SSIS returns an error that says: </p>
  
  <pre><code>Error at Data Flow Task [OLE DB Source [1]]: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005.
  An OLE DB record is available.  Source: "IBMDA400 Session"  Hresult: 0x80004005  Description: "CWBZZ5010 Error de comunicaciones con el sistema ###.#.##.# ".
  
  Error at Data Flow Task [OLE DB Source [1]]: Opening a rowset for ""XXXXXX".XXXX" failed. Check that the object exists in the database.
  
  ------------------------------
  ADDITIONAL INFORMATION:
  
  Exception from HRESULT: 0xC02020E8 (Microsoft.SqlServer.DTSPipelineWrap)
  </code></pre>
  
  <p>I hope you understand me, I have a pretty poor english. Ty</p>