ANSI-PADDING DTS job 1

[sanctified]

I've created a DTS job which will export data from a table into a text file using the delimited format.
The field is a char datatype of size 10 chars.
I need to be able to strip trailing spaces from a field how can I achieve this? I've tried using SET ANSI_PADDING ON/OFF within the script but the trailing spaces still appear.

Kind Regards

 

[mutley1]

If you're using a select statement to get the data, try:

select rtrim (my_column_name), etc. etc.

Rgds,

M.

 

[sanctified]

Thanks mutley1.

Works great!! cheers!!

 

[mutley1]

You're welcome.