How to use OUTPUT clause result in SSIS 2005 / 2008 (RC0)

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Gennadiy Chornenkyy... » How to use OUTPUT clause result in SSIS 2005...

How to use OUTPUT clause result in SSIS 2005 / 2008 (RC0)

Rate Topic

Display Mode

Topic Options

Author

Message

gchornenkyy

Posted Saturday, August 16, 2008 7:36 PM

Old Hand

Group: General Forum Members
Last Login: Thursday, February 14, 2013 2:39 PM
Points: 311, Visits: 277

Comments posted to this topic are about the item How to use OUTPUT clause result in SSIS 2005 / 2008 (RC0)

Post #553961

Samuel Vella

Posted Tuesday, August 19, 2008 2:12 AM

Old Hand

Group: General Forum Members
Last Login: Yesterday @ 2:22 AM
Points: 328, Visits: 1,852

Nice article, looks very similar to getting a list of values from a table and looping through them.

This is one of the things which I don't like about SSIS, sometimes it feels as if you're having to go through a lot of steps to acheive something which should be very straightforward.
In a perfect world you would be able to assign an output from an SP or function directly to a variable of the right data type.
Maybe with a custom script object in a package this could be done, I'll have to have a look Cool

A quick note on the layout of the article, I'm viewing it using IE7 and the code sections are fragmented with each line being in its own blue block. Very strange and never had this problem before on SSC.

Post #554801

gchornenkyy

Posted Tuesday, August 19, 2008 7:12 AM

Old Hand

Group: General Forum Members
Last Login: Thursday, February 14, 2013 2:39 PM
Points: 311, Visits: 277

Loyout looks a little bit strange in FireFox as well

Post #554986

Anipaul

Posted Wednesday, August 20, 2008 1:08 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 1:35 AM
Points: 4,789, Visits: 1,336

Nice one :)...

Post #555550

Elmer Miller-184883

Posted Tuesday, February 09, 2010 12:12 PM

SSC Journeyman

Group: General Forum Members
Last Login: Thursday, October 27, 2011 2:35 PM
Points: 98, Visits: 85

It seems there is virtually no direct support of the OUTPUT clause in SSIS Dataflows. It would be nice to be able to get back the output from an OLEDB command in a Dataflow. Does anyone know of a way to do this?

Post #862657

« Prev Topic | Next Topic »

Permissions