dbTalk Databases Forums  

DTS transfer limitation

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


Discuss DTS transfer limitation in the microsoft.public.sqlserver.dts forum.



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

Default DTS transfer limitation - 07-17-2003 , 11:26 AM






I am using DTS to transfer Oracle views into DBaseIII
files. By knowing DBase limitation of 255 columns per
table and 8 charactors for the table name. However, I am
still have error when using 254 columns to transfer around
250000 records. After I chop it down to around 70 columns
DTS works perfectly. How can I increase this buffer size
in DTS, so I can at least use around 200 columns.

Thanks for you kindness response.

Paul

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.