Hi,

I would like to schedule a job to execute a SSIS package. But the drop down of the New Job Step windows doesn't display the item "SQL Server Integration Service Package". So far I can only select "Operatin System (CmdExec)" and call DTexec.exe with all the arguments.

The SSIS Service runs OK, DTExecUI.exe to test the package also runs OK.

Q1. What is the reason the "Type" drop down box in the New Job Step windows shows so few options? (it only display ActiveX script, Operating System, T-SQL Script and some Replication xxx options).

Q2. What should I do to get the "SQL Server Integration Service Package" appears in this drop down?

Thanks very much in advance for any help.

 Please ignore. I connected to SQL Management Studio with a low privilege user account. Just reconnected with SA account and all options are visible.