execute ssis package (dtsx) from web interface...

[akalinowski]

is this possible?

something where a job is ran maybe w/ some form of web trigger, i dont have a clue what can be done, but i would like to have something run when a user logs on and presses a button to update info.

akalinowski

http://www.nofear.com

MCSE 2000, A+, N+, LCP, CNE

 

[mrdenny]

Yes you can have a web site start a job. The stored procedure to start a job is sp_start_job. Either make the owner of the job the account that the web site uses to log into the database, or setup the account that the web site uses as a member of the SQLAgentOperatorRole.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[mrdenny]

Sorry the SQLAgentOperatorRole is in the msdb database.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com