> Try www.sqlscripter.com to export data to text/csv. It's free.
>
> "Torrio" wrote:
>
>> Hello!!!
>> I am trying to build an SQL DTS Package which will export data from a
>> table
>> to a text file. The table has only one column and it ALWAYS has data.
>> No
>> nulls are allowed. The column length is 1500 but the data inserted
>> are not
>> always of that length.
>> The issue is that when I export using DTS, I want the trailing spaces
>> to be
>> trimmed off.
>> Is there any way to do it?
>> I tried using a query ("select rtrim(line) from wb_export) but I get
>> the
>> error msg "The Data Pump Task requires Transformation to be
>> specified"
>> Any ideas?
>> Thank you,
>>
>> Telemachos
>>