row size sql server 2000

#1

Good Morning,
I transfer a table from AS400 but my dts send an error.
THE MAXIMUM ROWSIZE IS 8060!!

The record in AS400 is of 10000.
Can I increase this parameter?

#2

The maximum rowsize in sql is 8060 bytes, and this can not be changed
What you can do is check if you have valid data type mappings, or you can decide to split u
the table in 2 parts using your dts packag

Regards

Dandy Wey
MCSE, MCSA, MCDBA, MCT

#3

thanks
"Dandy Weyn" <anonymous (AT) discussions (DOT) microsoft.com> ha scritto nel messaggio
news:BA402551-2E0A-45AA-A1C5-4E6D8BAD3D43 (AT) microsoft (DOT) com...

Quote:

The maximum rowsize in sql is 8060 bytes, and this can not be changed.
What you can do is check if you have valid data type mappings, or you can
decide to split up
the table in 2 parts using your dts package

Regards,

Dandy Weyn
MCSE, MCSA, MCDBA, MCT

#4

If you're using VARCHAR datatyp in your destination table, just use TEXT
datatype instead. Data in columns od TEXT (or NTEXT) aren't stored in the
row, it's just an pointer to data page.

"killer" <matteo.milano (AT) katamail (DOT) com> wrote

Quote:

Good Morning,
I transfer a table from AS400 but my dts send an error.
THE MAXIMUM ROWSIZE IS 8060!!

The record in AS400 is of 10000.
Can I increase this parameter?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

row size sql server 2000

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

row size sql server 2000 - 11-14-2003 , 04:07 AM

RE: row size sql server 2000 - 11-14-2003 , 04:36 AM

Re: row size sql server 2000 - 11-14-2003 , 04:55 AM

Re: row size sql server 2000 - 11-14-2003 , 06:06 AM