Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2004
    Posts
    33

    Unanswered: SQL DTS Source Without column headings

    If the SOURCE doesn't have column headings in a txt file (the format will be pipe delimited), how can I make it work (Through DTS) to load the source into my designed SQL Table? Thanks in advance!

    Jqiu

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Just specify the pipe character as the delimter? This one sounds too easy!

    -PatP

  3. #3
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    the DTS engine will name columns as Column1...n

  4. #4
    Join Date
    Mar 2004
    Posts
    33

    Re: SQL DTS Source Without column headings

    In the Text File Source, I unchecked 'the first row has column names' and it works. Thanks for the help!!!

    JQiu

  5. #5
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    I thought you did it before, but hey, you live you learn, huh?!

Posting Permissions

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