Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Weird Characters

Status
Not open for further replies.
emoongq

emoongq

IS-IT--Management
Jun 3, 2004
23
0
0
MX
I've created a DTS that was working great but since last thursday it is creating weird characters non ascii and don't know why, any idea?

Tks
 
Sort by date Sort by votes
I would suggest the bad data is probably in your input file or tables. I have found that these characters get in the database easily if someone imports data that was ever in an Outlook address book.

Are you importing or exporting?

"NOTHING is more important in a database than integrity." ESquared
 
Upvote 0 Downvote
I'm exporting to a txt file and never importing data to the source files
 
Upvote 0 Downvote
Most likely someone inserted those characters into the tables you are pulling the data from. Check them first for the characters you are seeing.

"NOTHING is more important in a database than integrity." ESquared
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
Import Limited to 255 Characters
Replies
1
Views
78
SaltyTheFrog
SaltyTheFrog
JD5241
  • Locked
  • Question
SQL Field - check for specific count of characters 1
Replies
2
Views
52
JD5241
JD5241
grnzbra
  • Locked
  • Question
205 Characters from VARCHAR(200) Field?
Replies
2
Views
42
grnzbra
grnzbra
bmacbmac
  • Locked
  • Question
Help with RegEx to find non alphanumeric characters
Replies
1
Views
283
ggriffit
ggriffit
VijiKumara
  • Locked
  • Question
Distinct query is returning weird result 1
Replies
2
Views
57
VijiKumara
VijiKumara

Part and Inventory Search

Sponsor

Back
Top