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!

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

maximum lenght of a record in a TXT file for import with dts

Status
Not open for further replies.

isonlyme

Programmer
Apr 20, 2002
171
PR
Hi pros

Im doing a DTS to load a txt file, but the record size on the txt is 1,020 in lenght, while im creating defining the columns and i go beyond 994 and save it i loose my definitions but if i stop at 700 i dont loose my definitons.
is there a limit on comlumns or record lenght for a txt when defining it...?

thanks in advance
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top