Orlando, thanks so much for this, and sorry for the delay in getting back to you. I was on vacation in Puerto Rico. 😀 I saw the 38th Column, but...

Here you go.

Ah hah. I edit attachments. Here is my masterwork. Thank you for your help, both past and future. 🙂

Thanks, I've tried your suggestion about using a Data Flow, but that just makes things worse: the file won't load at all and my error handling component isn't trapping anything....

Thanks, unfortunately, that's not it. Each line, including the last one ends with CRLF

Whoops. The ORDER BY clause in the original SELECT statement should've come after the "x" alias. I was typing it from memory since I'd already changed it on the server...

Yes, that's exactly what I mean.

I got the answer (from StackOverFlow, ahem). I need to fully qualify my object names. We have a mobile.Employee table and a dbo.Employee table. Three of us were staring at...

I apologize for not responding to this for so long. I got dragged away to a different project and in the meanwhile this issue became a moot point. I appreciate...

Ah ha! This looks good. It's almost 5:30 PM here, so I'm going to look at this tomorrow and let you know if it helps me, but it looks good....

Thanks Lowell - this function would work if I had a delimiter, but I don't. I just need to break the string every 4 characters by inserting a period, until...

OK, it's Monday, brain is (more or less) refreshed and I'm posting the text of the sp, including the T-SQL that seemed to be causing the code to not post...

SSCrazy Eights - thanks very much!

Lynn - I'd love to upload the file, but I can't figure out how to do that either. I think it must be Friday. :blush:

SSCrazy Eights - thanks for the warning. The input to this stored procedure, however, is done entirely through choices made in lists populated from the database. The user never has...