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

Can I add multiple strings or string variables to an Object variable in SSIS ? Expand / Collapse
Author
Message
Posted Friday, October 4, 2013 6:26 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Thursday, May 15, 2014 8:51 PM
Points: 183, Visits: 480
I am learning SSIS 2008. I am not sure if it is like regular OO programming. I was wondering if I can assign multiple String variables to an Object and then make a for loop iterate over these objects and do something. Is this possible ? If yes, then how to do it ?
Post #1501805
Posted Monday, October 7, 2013 9:14 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 10:12 PM
Points: 2,916, Visits: 2,515
The answer is yes - you can

The "for each loop" will iterate through various "objects". Personally, being a SQL type person, I would return the strings as a record set and iterate over that in the for each loop. However, there are other types you can iterate over - one of these may be closer to your list of strings.



Post #1502456
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse