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 error:DTS Wizard Error:Duplicate 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.
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 error:DTS Wizard
> Error:Duplicate 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.