Morning List,
Need some advice.
First I'll give you my specs:
5 year old server
running Windows 2000 with SQL Server 2000. ARSystem 5.1.2.
Process I am trying
to complete with my plans:
I have a feed coming
from an access database in the form of a csv file. It contains roughly 13,000
records. This data will be imported into a schema in Remedy every
month.
My plan:
the csv file is delivered, a scheduled DTS package truncates the temp
table in the database, imports the data and deletes the csv file. The temp table
is built as a View Form in Remedy and an escalation is run every night to
deliver the data to the schema that is used by the customer. This works. The
first import wasn't that bad, the second import took a couple of hours to
complete and the third took more than 5 hours to complete. Any ideas on how I
can make this automation faster or better?
Thanks
Eric W.
Dunn
Programmer Analyst III - Remedy/Collaboration
McLeod
USA, Inc. - Network
Engineering
8665 New Trails
Dr.
The Woodlands, TX
77381
(281)465-1265
(281)465-1951
fax
NOTICE: This electronic mail transmission may contain confidential information and is intended only for the person(s) named. Any use, copying or disclosure by any other person is strictly prohibited. If you have received this transmission in error, please notify the sender via e-mail.
__20060125_______________________This posting was submitted with HTML in it___
