Hi All,
Trying to edit an SSIS package, when I go to the advanced editor on the update database package I can only see on the component properties page three properties. ID, Name and Description.
when my colleague opens this up he can see 20+ options including the SQL option I am needing to be able to edit.
Is this an issue with my SQL Business intelligence studio 2005? or an issue with access to the end database?
Many thanks, Pierce
I'm guessing that you don't have something installed quite right. I'm betting you have Visual Studio installed, but not SQL Server development tools. First thing I'd probably do is verify that Help, About shows the same app information on both yours and your colleague's boxes.
-
so versions look good, BIDS is installed. Security? Easiest way to check that out is to have your colleague log onto your box using their network id. Not only will that check security, along they way, if there is something funky in your setup ( funky as in different from theirs not wrong ), your colleague is must more likely to spot it. AFTER that works out ok, THEN I might hazzard uninstalling and reinstalling Visual Studio. I don't believe I would mess with uninstalling and reinstalling anything .Net.