Problem with ODBC Source


  • Hello,

    I have the ODBC connection. When i try 'Test connection', it performs well. When i select any SQL command at ODBC Source, it performs well. But i have a problem with selecting any table at ODBC Source/ ODBC Destination. When i try to select 'Name of the table or the view' at ODBC Source Window, error raises:

    Error at Data Flow Task [ODBC Source [1]]: Open Database Connectivity (ODBC) error occurred. Failed binding table schema.
    (Microsoft Visual Studio). Error HRESULT E_FAIL has been returned from a call to a COM component. (Attunity.SSIS.Odbc.Design)


       at Attunity.IntegrationServices.DataFlowUI.ODBCUI.IAttunityConnectionODBC.SchemaGetTables(String[]& ppbstrTables, Int32 maxTablesNum, Int32& tablesFetched, String mask)
       at Attunity.IntegrationServices.DataFlowUI.ODBCSrcUI.connectionPage_GetLoadTables(Object sender, LoadTablesEventArgs args)

    Could you help me with this problem?

    SQLServer: Microsoft SQL Server 2012 with SP1

    Best Regards,

    Bakanchev Nikita

    • Edited by BakanchevN Friday, July 04, 2014 1:40 PM
    Friday, July 04, 2014 1:35 PM