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

[Glenn Baxter]

Bert, 
I would imagine so. I know that DTS Packages can be called using command
line (.cmd/.bat) from a remote client desktop shortcut.
The client (calling) machine needs to have SQL Server Tools installed in
order to do this.
Without knowing your network setup (fat client NETD Thin Client etc) I
would try a "run command" calling the server based .cmd and see how it
goes.
Sincerely
Glenn Baxter
Baxter IT Solutions
456 Victoria Parade 
East Melbourne 
Victoria Australia 3002
p: 03-9415-8733
m: 0412-826-503
f: 03-9415-8911
e: glenn at baxterit.com.au


-----Original Message-----
From: powerh-l-bounces+glenn=baxterit.com.au at lists.sowder.com
[mailto:powerh-l-bounces+glenn=baxterit.com.au at lists.sowder.com] On
Behalf Of Bert Onderdijk
Sent: Tuesday, 25 September 2007 12:33 AM
To: c
Subject: How to: Executing MS SQL-Server local packages with PoweHouse
/Axiant.

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


--
= = = = = = = = = = = = = = = = = = = = = = = = = = = = Mailing list:
powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to
powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the
list archive at Google.