SQL Server Performance Forum – Threads Archive

Problem importing W3C files

Hi, I am trying to import my IIS W3C files. The problem is that there are rows that have header information, and these rows all start with #. I think they get generated when certain events happen in IIS. Is there a way in a DTS transform data task to ingnore or skip rows starting with a #? I cant seem to find the setting. Thanks,
Eric

---

Nevermind… If DTSSource("Col001") = "#" Then
Main = DTSTransformStat_SkipRow
Else
Or something like that, still working on it. Thanks,
Eric

---

]]>