Developing data flows in SSIS

views:

101

answers:

Developing data flows in SSIS

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.

John Saunders 2009-04-01 11:53:52

Yeah, I eventually hit on the Row Count transformation...The idea of SSIS is great, the implementation and usability i'm not so sure....

Adrian 2009-04-01 13:26:27

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.

John Saunders 2009-04-01 13:34:48

+2 A:

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

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

Ed Harper 2009-04-01 14:57:01

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.

Adrian 2009-04-02 08:46:47

+1 A:

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.

Michael 2009-04-12 01:55:33

ansaurus

tags:

views:

answers:

Developing data flows in SSIS

related questions