SSIS to open application - with UI 1

[micang]

Hi All,

SQL Server Business Intelligence Development Studio 2008

I am trying to use "Execute Process Start" to fire up a certain application (that has a UI). The process works fine when I execute the process with in SQL Server Business Intelligence Development Studio itself, it opens the application (the UI). However when I schedule this package via a SQL Server Agent Job, the package runs, but the UI does not open, but the exe is running in the backround (task manager).

Is there away that I could schedule this, but to actaully open up the UI aswell?

Any help will be appreciated.

Michael

 

[mrdenny]

No. The application is running within the session that the SQL Agent runs under which is a background process that doesn't have console access.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog

 

[micang]

Thanks for confirming that nrdenny, appreciate it.

Michael