Madhu,
I had the same thing happen to me. It stopped once I created the path on my system that the sp is looking for.
Make sure that c:\SQLClasses folder exists.
Change the IF so it has the following:
IF @OLEResult <> 0 PRINT 'OpenTextFile ' + @FileName + ' error number:' + CAST(@OLEResult AS VARCHAR(20))
if you get the following:
OpenTextFile c:\sqlclasses\tablen.cs error number:-2146828212
This error number means the path is not found.
Bill Soranno
MCP, MCTS, MCITP DBA
Database Administrator
Winona State University
Maxwell 143
"Quality, like Success, is a Journey, not a Destination" - William Soranno '92