Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to use OUTPUT clause result in SSIS 2005 / 2008 (RC0) Expand / Collapse
Author
Message
Posted Saturday, August 16, 2008 7:36 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, April 30, 2014 11:35 AM
Points: 311, Visits: 284
Comments posted to this topic are about the item How to use OUTPUT clause result in SSIS 2005 / 2008 (RC0)
Post #553961
Posted Tuesday, August 19, 2008 2:12 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 2:06 AM
Points: 337, Visits: 1,981
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


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
Posted Tuesday, August 19, 2008 7:12 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, April 30, 2014 11:35 AM
Points: 311, Visits: 284
Loyout looks a little bit strange in FireFox as well
Post #554986
Posted Wednesday, August 20, 2008 1:08 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, July 17, 2014 10:36 PM
Points: 5,300, Visits: 1,378
Nice one :)...


Post #555550
Posted Tuesday, February 9, 2010 12:12 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC 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 »

Add to briefcase

Permissions Expand / Collapse