Hi Cory,
Probably the easiest way to achieve this would be a script transformation component.
In the script component editor, add a column to the output.
In the script designer, try something like this:
[font="Courier New"]Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)
If Row.Text.Contains(vbLf) Then
Row.OutputClean = Row.Text.Replace(vbLf, "")
Else
Row.OutputClean = Row.Text
End If
End Sub[/font]
I gave this a quick test with one of my tables and it seemed to pick up the linefeeds, so I'm guessing it would probably do the trick.
Let us know how it goes.
Kindest Regards,
Frank Bazan