Naeem,
I can't help you with HyperTerminal as I haven't used that in many years. Maybe someone else here can help with that. How are you creating the text file? In my case, my DTS package calls a VFP exe that does a COPY TO ... Then, in the next step of my DTS package, a Bulk Insert is performed on the text file. I don't have any problems with the file being locked. Also, my COPY TO statement copies the data to the SQL Server machine if that makes any difference.
HTH,
Chad
>Thank u v much Sir!
>Using SQL000 Personnel Edition Despite SQL7.0 and using BCP or Bulk INSERT; Processing speed increased. Now delay time decreased from 5 minutes to 1 minute approx. But there another problem increased; I can't use Bulk INSERT or BCP to fetch data from capture.txt file while caputre.txt file is opened in Hyper Terminal.
>To solve this problem I used xp_cmdshell to copy file from Capture.txt to Capture2.txt
>and then fetch data from capture2.txt using BCP
>but result is average processing time increased. Kindly guide me how can I fetch data directcly from a text file that is opened in HyperTerminal. In VFP and VB I can open this file in READONLY mode.(vfp fopen())(VB OPEN).
>Thanks alot again!
>
>Naeem
_________________________________
There are 2 types of people in the world: