Tuesday 12 May 2009

SSIS Packages Saved to SQL Server

When creating an SSIS package through a wizard, one of the options when saving it is to save it to SQL Server. However, when you do this the package may appear to disappear and cannot be found. The answer to finding these packages again is in SQL Management Studio, choose connect and choose Integration Services from the list.











Then, in object explorer, open the Integration Services instance for the server and drill down to find the saved SSIS packages.