Hi,
does anyone uses SSIS DumpLoad component in some loading framework that includes logging and monitoring? I need to be able to know results of such load and today it is not possible.
Today we still have (encapsulated) DTS DumpLoad package that is capable of know only load the data, but also provides at least some sort of output (receipt) - number of accepted and rejected records. In SSIS version this does not work (there are some sort of log files in users temp directory, but not in any reasonable format).
So, what is your experience, how do you fetch dumpload (or from any other ssis taks) result status?
I've been asking this question for some time now, there is a note on my previous asking, but still no resolution - note # 1346004
Radim