Query runs too long

[sleezy]

THIS QUERY RUNS FOR 3-4HRS AND I'M TRYING TO FIND OUT WHY. I'VE GOT THIS IN A dts
PACKAGE.I DELETE FROM THE ACCESS DATABASE FIRST THEN INSERT THE NEW DATA. THEY
ARE ABOUT 145000 ROWS.CURRENTLY CONNECTING TO THE ACCESS DATABASE USING ODBC CONNECTION.

HOW CAN I SPEED THIS UP ? I WANTED TO MOVED THE ACCESS DATABASE TO THE LOCAL SERVER
BECAUSE THIS WOULD SPEEP UP THE WHOLE PROCESS.bUT WAS INSTRUCTED NOT TO. WOULD OPEN QUERY BE A BETTER
OPTION ?

PLEASE ADVICE ..



--Open AdminDaily Table
SELECT *
FROM OPENROWSET
('Microsoft.Jet.OLEDB.4.0',
'\\abuser01\homedirectories$\Public Folder\Deviates\AdminOrders\AdminDaily.mdb';'Admin ';'', AdminDaily)
-- 00:2:25 Mins

[MAK]

Do you see any blocking in SQL Server when you were running this DTS?

[Rawhide]

I would look at optimizing your query. I have no doubt that the query is your slow down, not the connection.