Post reply

Can't find SSIS package in the job drop down list! please help

  • April 20, 2012 at 9:37 am

    #145237

    Hi,

    I have created some SSIS packages and they are working well on BIDS, I uploaded them to Inetgration server, and when I went to SQL Server Agent to create a new job, and added new step to read from the uploaded packages, I couldn't find the "SSIS Package in the TYPE drop down list .

    please help me, what can I do to add this option?

    Please have a look on the picture on this link

    http://www.mediafire.com/?w7tof6lpzf61edn

    Any help will be highly appreciated.

    Thanks,

    Hatem

  • April 20, 2012 at 9:39 am

    #1476759

    mota7128 (4/20/2012)

    Hi,

    I have created some SSIS packages and they are working well on BIDS, I uploaded them to Inetgration server, and when I went to SQL Server Agent to create a new job, and added new step to read from the uploaded packages, I couldn't find the "SSIS Package in the TYPE drop down list .

    please help me, what can I do to add this option?

    Please have a look on the picture on this link

    http://www.mediafire.com/?w7tof6lpzf61edn

    Any help will be highly appreciated.

    Thanks,

    Hatem

    http://www.mediafire.com/?w7tof6lpzf61edn

  • April 25, 2012 at 11:08 am

    #1479214

    Hi All,

    After investigating, I figured out that the server I was opening in SSMS is SQL 2000, and I tried to create a job on this server, and that's why I didn't find the SSIS package in the drop down list, as SQL 2000 doesn't support IS Server. To get over this problem, I created the job on SQL 2008.

    Thanks,

    Hatem

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply