Error Codes

If DTS can't complete an operation, it may provide an error code. This can happen either during the file-load operation, or during scheduling (in which case the error code is displayed somewhere in the task table).

These codes can be useful to better understand and resolve the application problem, and implement a solution as quickly as possible.

Code	Meaning
#UNDEF!	Usually occurs for invalid floating-point numbers (e.g. production fields), or if the result of a calculation exceeds the maximum allowable value of 20E20 (2,000,000,000,000,000,000,000).
#VALUE!	Can happen if the text result of a formula cannot be converted to a numeric value.
#NUM!	A calculation (maths) error has occurred, and the number cannot be represented in a human-readable format.
#DIV/0!	Division by zero. This could also be reported as #NUM! or #UNDEF!
#CIRC!	A circular reference in a formula has occurred. This should normally not go undetected during formula creation/parsing.
#REF!	Usually appears in a column header if a field has been removed that is still referred to by a table column. This column header may also be represented as <None>.