Export from table to Text files with DTS

#1

Hi, I'm exporting text files from a table. I want text file to have fixed
length fields but I want decide the fields length. When I create the
destination file connection, I can't change the length like I do with source
files connections. Is it posible to change it?

Thanks.

#2

In message <#Ccs1aX9DHA.712 (AT) tk2msftngp13 (DOT) phx.gbl>, fabian
<fabianbg (AT) navegalia (DOT) com> writes

Quote:

Hi, I'm exporting text files from a table. I want text file to have fixed
length fields but I want decide the fields length. When I create the
destination file connection, I can't change the length like I do with source
files connections. Is it posible to change it?

Thanks.

On the Destination tab of the DataPump, click Define columns. Use
Populate from Source to get a start point. Whilst you cannot add new
columns, you can ignore existing columns that come through from the
source, or change the size of the output column.
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

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

Export from table to Text files with DTS

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

Export from table to Text files with DTS - 02-17-2004 , 10:55 AM

Re: Export from table to Text files with DTS - 02-17-2004 , 11:31 AM