Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Can't find SSIS package in the job drop down list! please help Expand / Collapse
Author
Message
Posted Friday, April 20, 2012 9:37 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 26, 2014 7:35 AM
Points: 4, Visits: 22
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
Posted Friday, April 20, 2012 9:39 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 2:40 PM
Points: 20,863, Visits: 32,901
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



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
Posted Wednesday, April 25, 2012 11:08 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 26, 2014 7:35 AM
Points: 4, Visits: 22
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 »

Add to briefcase

Permissions Expand / Collapse