Is there a limit on the linesize of an output text file connection

#1

My DTS package outputs a TextFile from a table column that is varchar(2000).
The Max(Len(Mycolumn)) is 1403. The file is written OK but it appears that
the output records are truncated at about 256. Why? I need to output the full
width of the data! No errors and no warnings. Dangerous! How can I ouput
longer recs?

Thanks

Michael

#2

Not sure if it will help but you may check your ANSI_PADDING setting which
removes trailing white space and Zero's from varchar's dont know if it will
help the output though, but it may if it retaines the trailing white space
(and i am assuming it is dropping white space and not actual data...)

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

Quote:

My DTS package outputs a TextFile from a table column that is
varchar(2000).
The Max(Len(Mycolumn)) is 1403. The file is written OK but it appears
that
the output records are truncated at about 256. Why? I need to output the
full
width of the data! No errors and no warnings. Dangerous! How can I ouput
longer recs?

Thanks

Michael

#3

I recently had this. the old version of the wizard sets up the max length of
the fields to be 255. You can change this by opening th DTS package, go to
the package menu, disconnected edit, choose your destination connection, open
it up and change the Max Characters per delimited column to be larger.

-Good Luck!
Dave

"Snake" wrote:

Quote:

My DTS package outputs a TextFile from a table column that is varchar(2000).
The Max(Len(Mycolumn)) is 1403. The file is written OK but it appears that
the output records are truncated at about 256. Why? I need to output the full
width of the data! No errors and no warnings. Dangerous! How can I ouput
longer recs?

Thanks

Michael

#4

"David J. Cartwright" wrote:

Quote:

Not sure if it will help but you may check your ANSI_PADDING setting which
removes trailing white space and Zero's from varchar's dont know if it will
help the output though, but it may if it retaines the trailing white space
(and i am assuming it is dropping white space and not actual data...)

"Snake" <Snake (AT) discussions (DOT) microsoft.com> wrote in message
news:E9187292-F6B7-4D45-A6B7-CBFB47DA63C2 (AT) microsoft (DOT) com...
My DTS package outputs a TextFile from a table column that is
varchar(2000).
The Max(Len(Mycolumn)) is 1403. The file is written OK but it appears
that
the output records are truncated at about 256. Why? I need to output the
full
width of the data! No errors and no warnings. Dangerous! How can I ouput
longer recs?

Thanks

Michael

Actual data is being clipped!

#5

"DaveM" wrote:

Quote:

I recently had this. the old version of the wizard sets up the max length of
the fields to be 255. You can change this by opening th DTS package, go to
the package menu, disconnected edit, choose your destination connection, open
it up and change the Max Characters per delimited column to be larger.

-Good Luck!
Dave

"Snake" wrote:

My DTS package outputs a TextFile from a table column that is varchar(2000).
The Max(Len(Mycolumn)) is 1403. The file is written OK but it appears that
the output records are truncated at about 256. Why? I need to output the full
width of the data! No errors and no warnings. Dangerous! How can I ouput
longer recs?

Thanks

Michael

Thanks for the posting. This did not help. I am still getting my data
clipped!

#6

You may have to go to the transformation task & change the length of the
destination Field? Sorry it did not work for you (yet), mine turned out fine

"Snake" wrote:

Quote:

"DaveM" wrote:

I recently had this. the old version of the wizard sets up the max length of
the fields to be 255. You can change this by opening th DTS package, go to
the package menu, disconnected edit, choose your destination connection, open
it up and change the Max Characters per delimited column to be larger.

-Good Luck!
Dave

"Snake" wrote:

My DTS package outputs a TextFile from a table column that is varchar(2000).
The Max(Len(Mycolumn)) is 1403. The file is written OK but it appears that
the output records are truncated at about 256. Why? I need to output the full
width of the data! No errors and no warnings. Dangerous! How can I ouput
longer recs?

Thanks

Michael

Thanks for the posting. This did not help. I am still getting my data
clipped!

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

Is there a limit on the linesize of an output text file connection

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

Is there a limit on the linesize of an output text file connection - 09-08-2005 , 01:43 PM

Re: Is there a limit on the linesize of an output text file connection - 09-08-2005 , 02:02 PM

RE: Is there a limit on the linesize of an output text file connection - 09-08-2005 , 02:26 PM

Re: Is there a limit on the linesize of an output text file connec - 09-08-2005 , 02:56 PM

RE: Is there a limit on the linesize of an output text file connec - 09-08-2005 , 02:56 PM

RE: Is there a limit on the linesize of an output text file connec - 09-08-2005 , 03:36 PM