Thank you for your response. Our app times out after 30 seconds and inserts an error in the log file. The sp in question run in SSMS in...

I tried replacing the last column with 173 random characters to extend the row on those which are incorrect and it still imports incorrectly. I don't need that data...

I attached two rows of test data. The first one is correct and the second one is cut off. I put a CR at the end of each...

I tried using the derived column with the replace(column, "\r", "") and the data is still not getting the the right columns in the database. It appears that despite...

Awesome, thanks so much for your help, this is going to save me so much time. I can take it from here.

Thanks again,

Paul

Thanks for your help. I havent done much scripting could you please give me an example of how to get started with that?

Turns out there were several illegal characters screwing it all up.

I have honestly never used it before. Ill do some research and restructure the code. Thank you for the suggestion.

I'm having some trouble getting all of the elements into on long string. Maybe it will help if I post the code that I am trying to optimize. ...

Ill give SSIS a shot, thanks again for your help. Even though i was unable to solve this with a CTE i def learned more about them,

Thanks...

Yeah i see why the code you posted originally will not work. Thanks again for you time. Hopefully i can come up with something if nobody else can...

Well lets say we have the following addresses:

paul@yahoo.com

paul@gmail.com

First Name = Paul

Last Name = Smith

They want me to take paul as the first login and then paulsmith as the...

I just wanted to add that the email addresses are unique.

Awesome, thanks for your help. Now would i be able to add logic to lets say concatenate a first and last name if the login is taken? I...

Well the logic to generate a unique username depends on whether or not it already exists. So i could insert them one at a time into a temp table...