Execute SSIS in Navision

LorenzhoLorenzho Member Posts: 5
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

  • bbrownbbrown 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.
  • garakgarak Member Posts: 3,263
    yes it's possible with ADO
    Do you make it right, it works too!
Sign In or Register to comment.