DTS phases filter - informational question
Posted on 2005-04-29
I've got a dts job which functions just fine. I'd like, however, to improve the error handling -- like how many rows were inserted, what row failed if there was a failure, etc. I've enabled the 'show multi-pahse pump in dts designer' property. and now i am within the package itself, the transformations tab. i notice there are several new phases filters in addition to 'Row Transform' that I'd had already. The new ones, of course, are not mapped source/destination - I assume that I'd need to do that. All I'm wondering is whether or not by doing this I am going to alter/impact in any way the existing Row Transform? Can anybody give me a little more information on the right way to improve the error handling as I've mentioned above?