Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Script Library
 Special characters in input file

Author  Topic 

rongrzywacz
Yak Posting Veteran

57 Posts

Posted - 2001-10-19 : 10:47:52
I am trying to import a file to a db table from a mainframe system. When I look at it on the PC has some special characters in it. They look like nulls and or tabs. When I try to define the fields in DTS, I only see up to the first special character.
I tried to write a quick VB program to strip them out, but when VB is reading the file they get stripped out before I see them in the program.
Any help would be greatly appreciated.


Ron Grzywacz
   

- Advertisement -