Results 1 to 2 of 2

Thread: problems with DTS in SQL 7.0

  1. #1
    Marcos Jourón Berzosa Guest

    problems with DTS in SQL 7.0

    Hello:

    I am reciently installed SQL Server 7.0 Beta 2 and have a problem with de Data transformation services. The problem is that when I am try to import a text file to a table. The file is plain text, delimited with tabs and the first row has column names. Well if I check the `First row has column name` box and continue always give me an errorTS Wizard Erroruplicate column name ` xxxx`. I sure that there is no true, there is no duplicate names. Did it happen to anybody?, and if yes, What is the correct way to do it?.

    Thanks in advance.

  2. #2
    Guest

    problems with DTS in SQL 7.0 (reply)

    Is it possible that you have two tab characters in a row? If so, DTS may be mistaking that for a blank column name and getting confused.

    On 6/24/98 10:53:14 AM, Marcos Jourón Berzosa wrote:
    > Hello:

    I am reciently installed SQL Server 7.0 Beta 2 and have a problem
    > with de Data transformation services. The problem is that when I am try to
    > import a text file to a table. The file is plain text, delimited with tabs
    > and the first row has column names. Well if I check the `First row has
    > column name` box and continue always give me an errorTS Wizard
    > Erroruplicate column name ` xxxx`. I sure that there is no true,
    > there is no duplicate names. Did it happen to anybody?, and if yes, What
    > is the correct way to do it?.

    Thanks in advance.

Posting Permissions

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