From time to time I run into the problem that a DTS separately runs OK and in a package with more steps it will not run.
In most cases it says that "The number of failing rows exceeds the maximum: Unspecified error".
Even if I rewite the procedure the step repeats to fail.
What can In do about it?