question

kor4567 avatar image
kor4567 asked

Packages disappeared

Hi, After installing SP3 I can no longer see my packages. They are still being run according to schedule but I can no longer see them in Integration services. If I open de properties of a job and reconnect the package to it via the little explorer window I can see them just fine. But not in Integration services. The MSDB entry is also missing. I have tried several accounts, no luck. All accounts are domain admins. Al access rights seem to be properly set up. Also it is not possible to import or export any new packages into Integration services. There are no options avaiable. I am completely baffeled. Best regards, Cor
sp3
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Magnus Ahlkvist avatar image Magnus Ahlkvist commented ·
Where did you install SP3? On the client where you run Management Studio or on the server or on both?
0 Likes 0 ·
kor4567 avatar image kor4567 commented ·
It was installed on the cluster. All client tools were updated.
0 Likes 0 ·

1 Answer

·
Magnus Ahlkvist avatar image
Magnus Ahlkvist answered
It sounds a little like the same experience Sankar Reddy has blogged about: [ http://sankarreddy.com/2010/04/stored-ssis-packages-disappeared-after-sp3-migration][1]/ That suggests a missing configuration file. Have you checked error logs/Event log for error messages? [1]: http://sankarreddy.com/2010/04/stored-ssis-packages-disappeared-after-sp3-migration
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.