Re: text data import problem

#1

What is the datatype and size of the column you are importing to?

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

Quote:

I create a DTS to import a text file. This text file has different record
lengh by line. For example the line starting with "40" 740 of lengh and
the
line starting with "45" has 250.
The problem is that when I try to import the full text file, it is
truncating the file to 250. What could be the problem?

#2

Because you are using a text file then it may be that this may be your cause
although in the article it speaks of Exporting not importing.

DataPump truncates delimited fields to 255 characters
(http://www.sqldts.com/default.aspx?297)

Also HOW do you know it is being truncated?
Is the destination width large enough to handle the row sizes?
What tool are you using to view the data? It may be you have a maximum col
width set there (QA | options) so even though there is more data you are not
showing it.

--
--

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

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

Quote:

I create a DTS to import a text file. This text file has different record
lengh by line. For example the line starting with "40" 740 of lengh and
the
line starting with "45" has 250.
The problem is that when I try to import the full text file, it is
truncating the file to 250. What could be the problem?

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

Re: text data import problem

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

Re: text data import problem - 08-06-2004 , 12:21 PM

Re: text data import problem - 08-07-2004 , 03:14 AM