Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SSIS and Import/Export (2005)  Cannot view or modify a SSIS from local desktop

Author  Topic  CanadaDBA 583 Posts Posted - 2009-11-24 : 09:10:14 SQL Server 2005 SP2 I have some SSIS packages that are created by our developers. The Owner column when "Maintenance Plans" is highlighted shows their domain name; i.e. mycompany\loginname. Using SQL Management studio on my desktop and connecting as SA, when I open one of those pacakges, I can see the diagram but when doubl click on a box say "Update Statistics Task", It opens the box but all the fields and buttons except the "New..." button are disabled. If I do the same but on the server, I can see the values and able to change. I am not sure if this is related to ownership because I can open another package on my desktop from the same developer and can see all the fields and buttons are enabled. How can I open a package on my desktop as SA and be able to see or modify it? Why this is happening and how can I fix it? Thanks! Canada DBA