May 23, 2006 at 1:14 am
Hi,
If my application is using the SQL Server 2000 opendatasource import function to import excel file into our DB table for processing. However, it is taking up lot of resources and CPU usage. Any other way to improve on this area and resource. Thank you
May 23, 2006 at 3:28 am
Maybe DTS can do a better job for you.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
May 25, 2006 at 3:21 am
The excel of date is a lot ? unually no proble.
May 25, 2006 at 9:15 pm
Hi,
First, my excel file consists of 3 sheets only.
When I use the opendatasource to import the excel file, it is causing
high CPU usage and resource use. The data is not big in size.
I can't use DTS as it part of the SP that my web application will
call to run.
I am hoping to have other use to import my excel inside SQL server
without causing all those high CPU usage and resource.
Any advise is very much appreciated. Thank you
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply