How to: Executing MS SQL-Server local packages with PoweHouse / Axiant.

Mon Sep 24 09:32:36 CDT 2007

Dear PH / Axiant developers,

Would it -with your experience- be possible to start a MS SQL Server job
or Local Package with a specific statement inside Qdesign?

I know we can call stored procedures, but that's different thing.
- Jobs are typically called by the SQL Server Agent
- And local packages belong to Data Transformation Services and they can
be called by jobs... .
-> Could the best way be just trying sp_start_job?

Regards,

Bert

Bert Onderdijk
Piramide Operations

Kerkstraat 56
1354 AB
ALMERE

Tel.  : 036-8446010
Fax   : 036-5313610
URL   : http://www.piramide.nl
Mailto:B.Onderdijk at Piramide.nl