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