Hi guys,

thanks for your earlier help.

I now have a text file which has footer in the end with a date. I need to skip this line while executing my package as it otherwise results in error.

I can't seem to figure out how to do this. The import wizard just asks the no. of rows to be skipped(from the top) so it is of no use. I want to specify it to ignore the last row or better still any random row.

Thanks a lot

You can do 2 things
1
If the first couple of characters are always the same you could check it in your transformations like this
If DTSSource("Col001") ="footer" then
'do nothing
else
DTSDestination("Field1") = DTSSource("Col001")
end if

2
use the file system object and save the file without the footer

an excellentt DTS book is Professional SQL Server 2000 DTS (Data Transformation Services)
http://www.amazon.com/exec/obidos/AS...ink%5Fcode=xm2

http://sqlservercode.blogspot.com/

Thank you sqlmenace. Your solution gives me the desired result when I try in on a test package. I want to use this in my actual package which I had already created using the wizard (but at that time I had not selected ACTIVEX). Is there a way to add this script to my already created package? It is a pain to create the package all over again since I had created a number of column widths and names which would need to be redone. Thanks?

Oh, I just went and bought the book you recommended. I am in chap 2 now :)) Tks.