dbTalk Databases Forums  

Problem on import Ascii Text File

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Problem on import Ascii Text File in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Happy Li
 
Posts: n/a

Default Problem on import Ascii Text File - 08-17-2004 , 09:58 PM






I have a table with defined with two columns with datatype
of NChar(3) and NChar(60)
I want to import a text file with fixed length using
Import/Export Wizard. However, when I want to drop a
vertical line to define the columns width, 2 characters
are treated as "1 character" on screen!!! I can't put the
line after third character!! Anyone have the same
experience? Thanks a lot!

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.