SQL 2000 DTS Error: Invalid Column Length

[benchpolo]

I created a DTS process that extract data from a table to a .txt file using fixed-delimited column type. I have 39 fields in the SQL query script. When I execute the DTS process I am getting an "Invalid Column Length" error after I execute the transformation task, but when I switch to a delimited format I am not getting the invalid column length. Is there a limitation for a fixed length format?

Thanks.

[iburyak]

Is it possible that your fixed length is shorter then actual data in some records?
Try this on your table:

Select max(len(col1)), max(len(col2))........
From table_name

Good Luck.