SSIS Package (SQL Server) Execution from Access 97

P

Prince

Hi,

Is there any way to run SSIS Package from Access, it is not working with
"Run Application".

Any one please??
 
G

Guest

if it works on double click from windows explorer,
use Shell instead of run application
 
P

Prince

Hi,
Thanks for reply, but I never use Shell could you please send me some tips
on that?

Thanks for help again?
 
G

Guest

Example from Access help file:

Dim RetVal
RetVal = Shell("C:\WINDOWS\CALC.EXE", 1) ' Run Calculator.

Anything that the windows command shell recognises, that is anything
that has a registered extension, that is, anything that you can double
click on, like .doc or .mdb

(david)
 
Top