text file in sql

• hadidavinci

  Valued Member

  Points: 70

  More actions

  June 25, 2008 at 11:59 am

  #188423

  hi

  how can i store text files in sql2000?

  please help me

  thanks

• hmaharaj

  Right there with Babe

  Points: 781

  More actions

  June 25, 2008 at 1:00 pm

  #834225

  USE DTS

• tbeadle

  SSCommitted

  Points: 1635

  More actions

  June 25, 2008 at 3:24 pm

  #834318

  [font="Arial"]

  A little more clues are :

  A varchar(8000) is the default value you are prompted with in DTS. That doesn't mean you have to use all of that.

  Typically text files are 80 character per row, unless we are talking a table export row which could be a lot bigger.

  Either let DTS create your table with a single field of say 1000 characters like :

  create table text_file_table

  ( rowId int identity,

  text_line varchar(1000), null )

  Then put the text file data in that table via use of DTS or bcp.

  I suggested the rowId field as it's usually nice to have something on each row that you can use

  to edit the data easily with.

  Hope this helps,

  Terry

  [/font]