Thank you John and shieldj

Your ideas get me started..

John, I see ur point. with @@error, it can be checked if there is an error and if there is then the erronous...

I have the various sql statements to validate the data in DTS and i do row by row comparision by using cursors(not efficient but works... couldnt think of any other...

Hey Rapli

Thnx a bunch

This Does solve my problem

I was breaking my head w/ filesystemobject

but could not figure out wht i was doing wrong

Ur...

Hey Guys

Where can i find the File object

This is not there in the menu 

or If i have script, how should i reference the...