• After you save the package to a .dtsx file, you can import it into SQL Server by opening SSMS, connect to Integration Services, expand Stored Packages, right-click on MSDB, and select "import package...".

    Opinions vary on which storage location is better. We've chosen to store packages as files because we can use configuration files and because the packages seem to be easier to move from instance to instance.

    Greg