SSIS Tutorial – Problem with Error Redirection (Lesson 5)
Platform: Win Server 2003 Enterprise Edition
SSIS Version: 9.00.1187.00
I’ve been working my way through the SSIS tutorials and have noticed a problem when trying to redirect Error Output in lesson 5 “Adding Error Flow Redirection”.
Having configured the redirection to the ErrorOutput.txt file and running the package, when I went to view the contents of the file, it was empty.
I then removed all but the Currency_BAD.txt data file and re-ran the package. This time the file contained the error row.
Next I returned the other data files, but introduced an error row in the Currency_VEB.txt data file (as this is the last file processed in the foreach loop). I ran the package and watched its progress. I could see that and error row was redirected for both the Currency_BAD.txt and Currency_VEB.txt files, but on completion the only entry in the ErrorOutput.txt file was that from the Currency_VEB.txt file.
So it would appear that the package as it iterates through the loop would overwrite the contents of the ErrorOutput.txt file even if no error were produced.
Is this a bug or am I missing something in setting up the test?
Additionally is there anyway of re-opening the “Configure Error Output” dialog box after its initial configuration?
Thanks in Advance.
Anto
