Viewing Results which are not Output to a Destination

Question

When developing a Data Flow I don't always want to output the results to a destination - but I would like to see the data.

Is there a way to attach a Data viewer to an output without having to have a destination?

The file and raw destination have limitations on the data type they accept - and I don't want to attach conversions just to test/build code.

Is there some kind of output to null ? i could then get a data view on the result set

Answer 1

There is a (free) custom "trash" destination available from a third party:

http://www.sqlis.com/post/Trash-Destination-Adapter.aspx

Answer 2

There isn't really. You can use a RecordSet Destination, or a Row Count transform instead.

Answer 3

I usually use Export column transform - if left with default configuration, it does nothing, so it is equivalent to the custom "Trash" destination mentioned by Ed, but you don't have to install anything.

Answer 4

When debugging and wanting to view the data in the buffer, I usually throw in a Union All and connect it below the component who's output I want to see. Then add a Data Viewer on the connector and voila, there it is!