dbTalk Databases Forums  

Importing a large file...

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


Discuss Importing a large file... in the microsoft.public.sqlserver.dts forum.



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

Default Importing a large file... - 12-02-2003 , 03:03 PM






Hello all. I'm trying to Import (using DTS wizard) a
fairly large file. When I get to the screen where I
specify the starting/ending column positions, the DTS
wizard won't let me go beyond the 4095th column. My
record is 4288 characters. Is there a limitation on the
size of a record I can import?

Hope I didn't confuse anyone.

TIA
Roz

Reply With Quote
  #2  
Old   
Rufin
 
Posts: n/a

Default RE: Importing a large file... - 12-02-2003 , 06:11 PM






Max size of MSSQL record is 8Kb. It can create bigger but it will inform you then errors are possible.

Reply With Quote
  #3  
Old   
rOZ
 
Posts: n/a

Default RE: Importing a large file... - 12-03-2003 , 09:43 AM



ok, but my record length is 4,288 characters. Are you
saying the max record size is 8,000 characters? I'm SQL
2K by the way.

thanks
Roz

Quote:
-----Original Message-----
Max size of MSSQL record is 8Kb. It can create bigger but
it will inform you then errors are possible.
.


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.