activating ssis job whereby php 1

[lupidol]

Hi everyone.
I work with SQL SERVER 2005 and i have a job (SSIS job)which i'd like the user to activate whenever he wants.
My knowledge of PHP is rather poor but i thought PHP is the right intermediator between a USER and SQL Server.
The thing is i dont know how to create a link on a web page or some other menu wher a user can choose to activate a SQL 2005 job any time he wants.
Can i get help here ?
Thanks

 

[jpadie]

create a script that runs the job from php. typically this is just a query.
put the script on a webserver and tell your user what the address of the script is. simple as that.

if you want access control or other niceties then you can use .htaccess or a php form based system.

 

[lupidol]

Thanks but i didnt quite understand.
The job is consisted of many queries what kind of query do i have to write if the job is takins Excel table and transforms it into SQL ?
How do i insert that query into php ?

 

[jpadie]

if it's many queries then just run many queries sequentially. look at mssql_query in the manual. if the queries are stored in sqlserver as a trigger, then just call the trigger as if it were a trigger.

 

[Foamcow]

You can find information about the PHP functions that deal with MSSQL at

http://uk3.php.net/mssql

You will need to create a PHP script that

1. Opens a connection to your database (mssql_connect)
2. Submits a query (mssql_query)
3. Does something with the result (if needed) an reports back to the user (mssql_result)


If you are using stored procs then you can use the mssql_execute() function to trigger them

--
Tek-Tips Forums is Member Supported. Click Here to donate

<honk>*:O)</honk>

Tyres: Mine's a pint of the black stuff.
Mike: You can't drink a pint of Bovril.

 

[jpadie]

call the trigger as if it were a trigger

on re-reading that mis-type i can see it was less than helpful. Foamcow's answer provides, however.

 

[lupidol]

Thanks a lot