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 12»»

Data flow source Expand / Collapse
Author
Message
Posted Wednesday, March 03, 2010 10:05 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: Today @ 5:25 AM
Points: 3,683, Visits: 4,817
Comments posted to this topic are about the item Data flow source

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #876539
Posted Wednesday, March 03, 2010 10:33 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 2:36 AM
Points: 110, Visits: 327
Tricky...
Post #876554
Posted Wednesday, March 03, 2010 11:38 PM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Sunday, January 19, 2014 5:00 PM
Points: 605, Visits: 1,690
A good QotD.

In the interest of developing the discussion I'd put my 2 cents down as: if you have a convenient disk location a raw file destination+source is likely easier to use than a recordset+script.


S.
Post #876582
Posted Thursday, March 04, 2010 2:36 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, April 14, 2014 3:48 AM
Points: 987, Visits: 858
Good question... Yet again, I learn something new over my morning tea


Post #876657
Posted Thursday, March 04, 2010 2:55 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, March 13, 2014 4:10 AM
Points: 2,296, Visits: 1,424
Good Question i thought that it would be Raw File Source But nope.........good and very typical one
Post #876663
Posted Thursday, March 04, 2010 2:56 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, March 13, 2014 4:10 AM
Points: 2,296, Visits: 1,424
http://www.simple-talk.com/sql/ssis/ssis-package-componentization/

Post #876665
Posted Thursday, March 04, 2010 10:24 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 5:12 PM
Points: 20,458, Visits: 14,081
Thanks. I learned something today.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #876975
Posted Thursday, March 04, 2010 1:31 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Yesterday @ 10:33 AM
Points: 17, Visits: 115
It seems to me the ADO.NET datasource is also a valid answer. A ForEach Loop Container can also reference an object variable as a datasource via ADO.NET. See the following post.

http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/64014/
Post #877135
Posted Friday, March 05, 2010 12:00 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 2:13 AM
Points: 1,864, Visits: 368
thanks..
Post #877419
Posted Friday, March 05, 2010 9:49 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Friday, January 03, 2014 10:59 AM
Points: 626, Visits: 836
carl-793059 (3/4/2010)
It seems to me the ADO.NET datasource is also a valid answer. A ForEach Loop Container can also reference an object variable as a datasource via ADO.NET. See the following post.

http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/64014/


Ya, I do this all the time, so I picked an ADO datasource and got it wrong.
I demand a refund!



Craig Outcalt



Tips for new DBAs: http://www.sqlservercentral.com/articles/Career/64632
My other articles: http://www.sqlservercentral.com/Authors/Articles/Craig_Outcalt/560258
Post #877756
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse