General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only