We solved this by exporting the data to the file and following up with a Script Task that uses VB and Regular Expressions to remove the line breaks from the...

Thanks a bunch. Wow!! That's exactly what I needed.

-------------------------

"Computer games don't affect kids; I mean if Pac-Man affected us as kids,

we'd all be running around in darkened rooms,...

You'll have to forgive my ignorance, but would that be, in effect, creating a dynamic connection object? Can you point me to some tutorials on Active Scripting. I...