Thanks david,

I can read / write using the stream object. However I am dealing with 3 tier architecture the problem is I don't have ADO at the front end.....

create a record set, set the value of the image field to the stream object

To database:

rs.fields(0).value = streamobject.read

From database:

streamobject.write rs.fields(0).value

abdul

that was a quick reply!

abdul

hi friend,

I have done something similar for a project I was doing recently. I did not use vbscript though.

I looked for a file at a given location using xp_fileexists. If...

You're code does work even if you don't supply the file name..

e.g. EXEC master..xp_cmdshell 'DIR E:\Dev\Data\OrdercanceReject\*.zip /T:C'

will give

Volume in drive E is E

Volume Serial Number is 942B-B387

NULL

Directory of E:\Dev\Data\OrdercanceReject

NULL

28/03/2002 ...

unfortuantly I don't know the name of the file. It is zipped file of the name

RSP_MIReportsddmmyy.zip.

I have resorted to VB and have used the FileSystemobject...

I created a little VB app,...

can't you use SQL Server's BCP instead, are you doing any formatting with thetext file? before the data from the file ends at its final destination?

abdul

Thanks.

I have done it..

I have used the sql server stored proc. sp_update_jobscehdule and some TSQL to check for current time and have achieved what I wanted. Basically I look for...