Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Stewart Campbell » Data flow source
Add to briefcase
15 posts, Page 2 of 2
««12

Data flow source Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
Raghuram (AJ)
Posted Wednesday, March 10, 2010 8:53 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, June 15, 2012 7:53 PM
Points: 494, Visits: 299
I usually choose ADO and loop through it...and it works. Give me my 2 points!

The vision must be followed by the venture. It is not enough to stare up the steps - we must step up the stairs. - Vance Havner
Post #880310
Joshua M Perry
Posted Wednesday, March 10, 2010 9:13 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, June 17, 2013 4:30 PM
Points: 388, Visits: 419
I've used ADO.NET this way, and it even says it's possible in the provided documentation:

The source converts any data type that does not map to a specific Integration Services data type to the DT_NTEXT Integration Services data type. This conversion occurs even if the data type is System.Object.

Joshua Perry
http://www.kerry.com
Post #880332
Stewart "Arturius" Campbell
Posted Wednesday, March 10, 2010 10:33 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 8:26 AM
Points: 3,164, Visits: 4,344
Please note the content of the question:


To use the data from this variable in the future data flows, what data source component must be used in each dataflow?


i.e. within the context of a dataflow component, not in the control flow.

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #880691
Paul White
Posted Tuesday, March 30, 2010 8:17 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 10:48 AM
Points: 10,990, Visits: 10,578
My SSIS is apparently getting rusty. Must find an excuse to use it again, soon.


Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #892816
Heart Break
Posted Thursday, April 29, 2010 8:54 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, February 01, 2013 6:56 PM
Points: 24, Visits: 21
I think, the ADO.NET data source is capable of handling the record source as a vairiable too. I use this all the time.
Post #913370
« Prev Topic | Next Topic »

Add to briefcase
15 posts, Page 2 of 2
««12

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.