• Status: Solved
  • Priority: Medium
  • Security: Private
  • Views: 36
  • Last Modified:

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

Example...
This select...which I can see....
0|lbrister|Experts-Exchange

Is in my text file like this
None0None|NonelbristerNone|NoneExperts-ExchangeNone
0
Larry Brister
Asked:
Larry Brister
  • 2
  • 2
1 Solution
 
Jim HornMicrosoft 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.
0
 
Larry Bristersr. DeveloperAuthor Commented:
Thou cracketh mine heart to pieces!

How in the Lord's Good Green earth did THAT happen????
0
 
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.
0
 
Larry Bristersr. DeveloperAuthor Commented:
Thanks...appreciated.
0
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.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now