Posted by Plamen Ratchev on 01/24/07 02:07

Hi,

If I understand correctly you want to eliminate the first row in the result
text file which contains the field names. In your code you have a loop that
writes those to the text file:

> For i = 1 To oRSc.Fields.Count
> objTextFile.Write oRSc.Fields(i-1).Name
> If i < oRSc.Fields.Count Then
> objTextFile.Write " "
> End If
> Next
> objTextFile.WriteLine

Just comment out the section above and it should no longer write the field
names to the output file.

Regards,

Plamen Ratchev
http://www.SQLStudio.com

• Next in forum: Re: DTS question reguarding text import and tranformation
• Prev in forum: DTS question reguarding text import and tranformation
• Thread view: Re: SELECT statement - How to not get column field names?

[Reply to this message]