SSIS Package (SQL Server) Execution from Access 97

[Guest]

Hi,

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

Any one please??

 

[Guest]

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

 

[Guest]

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

Thanks for help again?

 

[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)

 

[Guest]

Thanks for your help and time, it is really helpful for me.