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 ]: 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)
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.