Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Source Script Component

Author  Topic 

barretld
Starting Member

22 Posts

Posted - 2009-04-14 : 16:50:42
Need to know the .net code for skipping the first row in a flat text file that has column names using a script component. Another words, developing .net code in a source script component trying to skip the column names in the first row of the text file. Normally, one would not write .net code and use the "flat file source" and in this use the ColumnNamesInFirstDataRow = true.

Learning the Source "Script Component", need some code examples. For the ColumnNamesInFirstDataRow, this is not usable in developing code in .net.

Thanks.

barretld
Starting Member

22 Posts

Posted - 2009-04-15 : 10:50:39
Nevermind, this is the code I am using, skips first line. nextLine = textReader.ReadLine()
Go to Top of Page
   

- Advertisement -