Re: load data to SQL table by using DTS

#1

I they are varchar then, whilst it isn't what you want, a varchar will not
destroy your ability to run things. Are you letting SQL Server create the
table? This dialog is editable.

Are you sure you are not seeing this

814113 - FIX DTS Designer May Generate an Access Violation After You
Install SQL Server 2000 SP3
http://support.microsoft.com/default...B;EN-US;814113
--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know

"sere" <sere (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hi,everyone:
I am trying to load a comma delimited file into a SQL 2000 table. I got an
error msg of exception_access_violation. " The table has been created, but
the maxim row size exceeds the max number of bytes per row."
I open up the table in design window and found that by default all my
column
length is set to 8000. How does this happen? I didn't set up the length of
each column to 8000. I have my column length from 4 to 100 but not over
100
for each column.
Does anyone have any idea ?
Thank you in advance.
P.S.
is there a value/property to set up in SQL 2000 server? I run the same
program in another machine (installed SQL 2000 home version) and it works.
The table created with no error.

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

Re: load data to SQL table by using DTS

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

Re: load data to SQL table by using DTS - 08-11-2004 , 03:42 PM