I did get Jeff's method to work in SQL Server Management Studio with the following code:

SELECT(STUFF((SELECT ', '+AS1.Source

FROM Agent_Source AS1 INNER JOIN

Agent_Source_Release ASR ON ASR.Agent_Source_ID = AS1.Agent_Source_ID

WHERE...

No, not looking to simply concatenate strings, but the DataSet (array?) values. I am looking for a tool or method to iterate through the DataSet and concatenate all of...

I'd like to perform the report formatting using SSRS expressions if possible, but maybe I'll end up doing it in the SQL code if I can't find another way. ...

A former instructor helped me find the answer to my problem.

Click either on the DFT in the Control Flow level or on the canvas in the DFT level...