We see this coming up quite a bit on newsgroups and even have people eMailing about it so we though we would put up an article explaining where to find packages when saved to SQL Server.

If you want to view them visually in SQL Server Management Studio then you will need to connect to the Integration Services Service for the Server on which you have stored the packages.

Below is an example of us connecting to the service by first opening up Object Explorer and then connecting to the Service by choosing it from the dropdown menu and then using Integrated security (no choice here) to login to that server.

Open Object Explorer

Choose Integration Services Service

Logon to the service

Look at your packages