ETL and Data Integration tools - Modern ETL software for everyone

Hi,

We are using VImP to extract data from an ODBC (NonStop ODBC/MX 2.0 ver 3.51.20.126 Date: 2006-11-13) to an SQL Server 2005 Standard Edition. When we are using a query to extract data the NonStop driver reports a warning like:

Error 2011-05-29 13:09:41 Execution of Export Script failed
Error 2011-05-29 13:09:41 SQLExecDirect(FHSMT,PChar ('+sql+'), SQL_NTS) Failed: 01000 [HP][ODBC/MX Driver][NonStop SQL/MX] SQL warning:*** WARNING[6008] Statistics for column KORNINGSNR were not available. As a result, the access path chosen might not be the best possible.
Error 2011-05-29 13:09:41 Package Failed

Is there a way to ignore warnings and not to fail the export script?

Thanks in advance

Henry

Hello

Can you try the latest version please

Changes are

ODBC Connection String Builder Was Introduces
Support for FTP Directory Listing
Improved support for NonStop ODBC/MX 2.0 ver 3.51.20.126 ODBC Driver
Various Cosmetic Changes and Bug Fixes

Mike

Update your statistics of de nonstop table.
You can supress the warning thru adding: set session warnings off;