I made a data source with this propierties:
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:
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)
I hope you understand me, I have a pretty poor english. Ty
I tried with ADO NET manager Connection and It works. Ty all