In SQL 2005, I am creating a new package that I want to save in SQL server.
Per the documentation, I should be able to select "Save Copy As" from the
file menu, however I don't see this option, nor do I see any other way to
save the package to SQL from the SSIS designer.

I am able to import the package to SQL from within the SQL Server management
studio by connecting SSIS, and right clicking on MSDB,however would be nice
to be able to do this from within the designer, as the documentation leads me
to believe I should be able to do.

Does anyone know how to do this?

Thanks.

If you have any unsaved changes to your package that option will not appear.
Try hitting the save button first then looking for the Save Copy As option.



"Jenny Wilson" wrote:

I tried this - and still I don't see the option. The closest thing I see is
the "Save <package name> as", which opens the normal dialog for saving a file.

Jenny

"Jaime" wrote: