dbTalk Databases Forums  

Import text file into Table

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


Discuss Import text file into Table in the microsoft.public.sqlserver.dts forum.



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

Default Import text file into Table - 07-18-2003 , 03:31 AM






Hi,

I have created a table with a single field to import my text file into. The
problem which I am having is that I cannot get DTS to import a file which
has not CR/LF to mark the end of the line. Instead there are NullChars. The
problem extends itself inthat the Null does not show the end of the line in
other lines.

How can I tell DTS import tool that my line is 254 characters long and not
need to worry about the end of line character.

Thanks,
Yossi



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.