Loading one of my queries fails, the Load window simply displays a message that says: "OLE DB or ODBC error: [DataFormat.Error] We couldn't convert to Number.." The error message should display the field or value that can't be converted to a number. Otherwise this error message isn't helpful at all The typical advice of checking the data in the Query Editor preview is not helpful either when working with large datasets, many queries, or queries with many steps since the error may not appear in the preview.
2 Comments
Should apply to errors reported on gateways too - no use without column info.
- Status added:New
