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
-
There isn't really. You can use a RecordSet Destination, or a Row Count transform instead.
Adrian : Yeah, I eventually hit on the Row Count transformation... The idea of SSIS is great, the implementation and usability i'm not so sure....John Saunders : SSIS takes some getting used to. Fortunately, there are a lot of resources. Start at http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/24d6967c-a11a-488a-9811-bd50a1a98322, and follow the links to the blogs. Watch that forum for interesting posts, too. -
There is a (free) custom "trash" destination available from a third party:
http://www.sqlis.com/post/Trash-Destination-Adapter.aspx
Adrian : That sound exactly what I was after! The next question is why isn't it available out of the box? The separation between DBA and dev is not that wide. -
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.
0 comments:
Post a Comment