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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » SQL Server Agent » Can't find SSIS package in the job drop down...

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

Rate Topic

Display Mode

Topic Options

Author

Message

mota7128

Posted Friday, April 20, 2012 9:37 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, November 02, 2012 6:05 AM
Points: 4, Visits: 14

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

Post #1287277

Lynn Pettis

Posted Friday, April 20, 2012 9:39 AM

SSC-Insane

Group: General Forum Members
Last Login: Today @ 9:22 PM
Points: 21,633, Visits: 27,492

mota7128 (4/20/2012)

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

Cool

Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)

Post #1287279

mota7128

Posted Wednesday, April 25, 2012 11:08 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, November 02, 2012 6:05 AM
Points: 4, Visits: 14

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

Post #1290123

« Prev Topic | Next Topic »

Permissions