I received the following error on a failed DTS package 'The number of failing
rows exceeds the maximum specified. Unspecified error'.
I found the following error in the package log:
'Step Error Source: Microsoft OLE DB Provider for SQL Server
Step Error Description:The statement has been terminated. (Microsoft OLE DB
Provider for SQL Server (80004005): Subquery returned more than 1 value. This
is not permitted when the subquery follows =, !=, <, <= , >, >= or when the
subquery is used as an expression.)
Step Error code: 80004005
Step Error Help File:
Step Error Help Context ID:0'
I increased the Maximum allowed errors to 9999 to get the package to run
successfully. Is there anyway to find the errors that were creating the
package to fail?
Message posted via http://www.yqcomputer.com/