Problem:

Trying to import a VISION file through a DTS package and error is being encountered:

------------------------ Actual error from DTS package --------------

Step Error Source: Microsoft OLE DB Provider for ODBC Drivers

Step Error Description:[AcuCorp, Inc.][AcuODBC Driver]Assignment error

Step Error code: 80074005

Step Error Help File:

Step Error Help Context ID:0

Resolution:

This error, "Assignment error", is caused by non-numeric data in a numeric field.  Their are two solutions:

1) fix the data in the file correcting or removing the invalid data

2) On the Advanced tab of the DSN change the specification of  the Invalid Numeric Data option from Error to Zero or Null.