Execute SSIS in Navision

Lorenzho
Lorenzho Member Posts: 5
edited 2008-05-22 in NAV/Navision Classic Client
Hello

I have a SSIS stored in to msdb database and I want to execute it in to the form in Navision. Is it possible to execute the SSIS without to install sql2005 in every Navision Client 4.0 SP3?
My pourpose is to write a procedure in navision to connect the database and run the ssis with command dtexec. Is it possible?

Thanks in advance.
Lorenzo

Comments

  • bbrown
    bbrown Member Posts: 3,268
    I'm using ADO to trigger the execution of a SQL Agent job from within Navision. I would think you should be able to use the same approach with SSIS.
    There are no bugs - only undocumented features.
  • garak
    garak Member Posts: 3,263
    yes it's possible with ADO
    Do you make it right, it works too!

Categories