SQL Server Performance

New Job Step, Integration Service Package NOT showing

Discussion in 'SQL Server 2008 Questions [Archive Only - Closed]' started by Zirco, Oct 6, 2008.

  1. Zirco New Member

    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.
  2. Zirco New Member

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

Share This Page