dbTalk Databases Forums  

Can't edit scheduled SSIS package

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Can't edit scheduled SSIS package in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
dw
 
Posts: n/a

Default Can't edit scheduled SSIS package - 11-08-2006 , 02:18 PM






Hi. I'm able to create a job to run an SSIS package in SQL 2005 okay, but
can't edit the job after the fact -- all the edit options are grayed out.
What am I missing? It says the package is owned by me (domain\username), but
then all the edit options are unavailable. The job is being run under a
proxy account and I have the permissions to the MSDB database to create
jobs, and am part of the following roles,

- operator role
- SQLAgentOperatorRole
- SQLAgentReaderRole
- SQLAgentUserRole
- db_dtsadmin
- db_dtsItduser

Thanks.



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.