Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    3

    Unhappy Unanswered: 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,
    Craig

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Why 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...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Nov 2003
    Posts
    3

    BCP

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •