CODEWITHSUNDEEP
sqlvariablesssisresultset
IMTheNachoMan
IMTheNachoMan

Reputation: 5833

access SSIS Result Set Object Variable like an array

I am using the Execute SQL Task and have ResultSet set to Single row. I know in the Result Set section I can use column indexes to save the data in the result to different variables (like so).

I am wondering, if I save the entire row to a variable of type Object, is it possible to access the different columns of that variable like an array or something? I know I can do this in a Script Task but I wanted to do it in the expression builder.

Upvotes: 2

Views: 1796

Answers (1)

digital.aaron
digital.aaron

Reputation: 5707

Unfortunately, no, you can't access the data inside an object variable in an expression. Using a Script Task, or a Foreach Loop with an ADO Enumerator, are really the only ways to access the data inside the object.

Upvotes: 1

Related Questions