Preamble:

And, "Welcome Back" to SSC... this is only your 4th question and 18th post in 15 years.  I hope that means that you and yours are doing well. 😀

Thanks...

On your DR Doc, I would document what the role is of Each server then in what order they will take in the event of a failure. ie how to...

Yes Jeff you are correct.

in the picture attached is what i am trying to achieve but with only a single digit it is throwing off the next record set.

• This reply was modified 1 year, 4 months ago by  James Reed.

Sorry Jeff, I had posted it before...but here is a better view of the strings i am dealing with.

UIMth: 07/01/23 UISeq: 3218 Line: 1 Reviewer: MAH

UIMth: 07/01/23 UISeq: 3218 Header...

How can i adjust the substring to grab from 1 to 4 numbers in the UISeq?

SELECT UIMth = substring(t.yourcolumn, 8, 8)

, UISeq = substring(t.yourcolumn, 24, charindex(' ', t.yourcolumn, 24) -...

Thank you, that helped allot.

Jim

what worked? creating a valid CSV file or removing potentially valid data from your output? and if removing valid...

Thank you frederico_fonseca,

That actually worked for me.

e.g. on your SQL statement source (or on your SP if that is the source of the data) you do

select xxx

,...

Thank you for you input, that actually worked for me.

Here is a small sample of the end of the records with the phantom CRLF

,,,04/09/1991 00:00:00,04/09/1991 00:00:00,,,,SALARIED MANAGER,6328,Y,801

,,,09/18/1991 00:00:00,09/18/1991 00:00:00,,,,PG 105 AFCO LR 1ST,6194,N,201

,,,01/20/1992 00:00:00,01/20/1992 00:00:00,,,,PG 105 AFCO LR 1ST,5970,N,201

,,,01/23/1992...

Yes i had to do it that way then vendor wants the dates in a specific format and that was the only way I knew how to achive that... and...

If that is not the correct way to do dates then what is? I have used that way for a long time...but if you have a better way then by...

Thank you, i guess I had just looked over it.....it was set to dbtimestamp in the output.....thank you for that...

Omri script works great. I have used it a couple of time.

Thanks for all your imput. It is kind of funny that i posted this on Microsoft also and got a better response from sqlservercentral than them.

Thank guys