lol, No I don't work there, and have choose to find a different place to work myself after years of this.

Myself, I hit the INFP, which seems to be in...

The main difficulty I am seeing (and directly impacting my job) is people neglect to use these sorts of tools as a way to relate to others. The secondary...

Thank you all. I think with the responses so far I can get this working.

Yes. It is a file with fixed width fields & rows, but without any delimiters of any kind.

The row delimiter in this case is the issue. The data file has no row delimiter. Not even the lowly LF.

I have just finished audio versions of the entire Dresden series, and Butcher's Codex of Alera series. Nicely entertaining.

If you like fantasy, give a try to Brent Week's Night Angel...

I have been using the bulk insert task as I convert dts to ssis, when working with text files. It is not as simple as the import tool, but...

Sean, I had not seen the attachment before, very tempted to print and hang at the enterance to IT...

Lynn, yes, I have two people whom I have been able to...

Yes, yes they are.

I have spent many many years attempting to save them from themselves.

Jasmine, not only did that make me laugh, but is dead on. It is stunning the level of blaming/refusals etc people can manage when they realize something might hold them...

Lack of a perfect world is the difficulty I am dealing with. Essentially I have certain limits which are not something I can change. (I can and do try to...

Terriffic point! I can hardly imagine how much a team could learn if everyone on it had that same idea.

Ahh, I keep forgetting the For XML path idea. I will have to play with that until I understand it.

Thanks!

Thanks for the idea's from both of you. I like having more than one tool for the task. So for those SSIS is not the best choice XML path should...

Well, we did find out it was executing the stored proc 3 times.

This link confirmed what we were seeing

http://social.msdn.microsoft.com/Forums/en/transactsql/thread/b8340289-7d7e-4a8d-b570-bec7a0d73ead