Copy SSIS Package from SQL Server msdb to file system

  • Hi,

    This is my first time posting so I hope this is the right place for my problem.....

    I have created an SSIS package to import data from Access using the SQL Server Import and Export Wizard. I chose to save it in SQL Server rather than the file system but now I need a copy saved as a dtsx so that I can use it on another computer (at university).

    Is there any way in which I can do this or will I have to create the package again?

    Many thanks in advance.

  • In SSMS, connect to Integration Services from the Object Explorer. Under Stored Packages expand MSDB, right-click on the package and export.

  • Great!

    Many Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply