Executing Access Query From Within DTS

#1

Hi Everyone

Is it possible to execute MS Access Query from within a DTS package.

In the connection to the Access database the queries within the .mdb don't
seem to be exposed

Many thanks

geoff

#2

They may not be lsited but you should be able to treat them as you would a
stored procedure, e.g.

EXEC MyQuery

--
Darren Green
http://www.sqldts.com

"qqqq" <dddh (AT) ddd (DOT) clc> wrote

Quote:

Hi Everyone

Is it possible to execute MS Access Query from within a DTS package.

In the connection to the Access database the queries within the .mdb don't
seem to be exposed

Many thanks

geoff

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Executing Access Query From Within DTS

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Executing Access Query From Within DTS - 01-28-2004 , 06:42 AM

Re: Executing Access Query From Within DTS - 01-28-2004 , 07:02 AM