DTS and Fixed Widths

Hi all.

I'm trying to export some tables in fixed width format for a client that needs it this way. The first time I did this, using Import/Export in Enterprise Manager, integer fields were 12 chars long. However, when I saved this as a DTS and ran it again later, it made integers 4 chars in the text file (which matches the lengths of the datatypes you see in enterprise manager.)

Why is this difference there? What do I need to do differently? Also, is there a list of how wide each data type is when exported as fixed delimited text?

thanks,
CraigWhy don't you use bcp in a sproc with format files?

And as far as DTS changing widths...I don't think (damn it, happened again) so...|||I assume you're talking about Bulk Copy? I haven't done that before, but its definitely an option -- I just ASSUMED DTS would be easier.