SSIS Text export anamoly

I've had an export that's been running automatically for wuite some time.

Gets data from SQL and sends to a txt file | delimited

Out of the bule, each column is gettinga leading and trailing 'none' string

This select...which I can see....

Is in my text file like this
Who is Participating?
Jim HornConnect With a Mentor Microsoft SQL Server Developer, Architect, and AuthorCommented:
Eyeballeth thy connection's TextQualifier property, and change the 'None' you are seeing in the output to <none>, or maybe blank.
lrbristerAuthor Commented:
Thou cracketh mine heart to pieces!

How in the Lord's Good Green earth did THAT happen????
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Donteth know, but my last gig had an SSIS template with an _0x0_ in there, and it really drove them crazy.
lrbristerAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.