Post reply

SQL 2005 Import\Export Wizard package save location

  • October 8, 2012 at 9:36 am

    #393335

    When i use the import\Export to move data and select the option to save as an SSIS package it says it will save it in SQL Server. What is the actual file location and can I access it with SSMS?

  • October 8, 2012 at 1:43 pm

    #1546897

    You posted in a 2008 forum but it looks like from the title of your post you're on 2005.

    Here is a link on how to connect to a SQL 2005 Integration Services Instance:

    Connecting to a Remote Integration Services Server (SQL Server 2005)

    When you 'save to SQL Server' where you're really saving the package is in the msdb Database of the SQL Server you specify. You can see your packages here:

    SELECT *

    FROM msdb.dbo.sysdtspackages90;

    And you can access them via SSMS, just follow the link above.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • October 10, 2012 at 9:45 am

    #1547732

    Thanks you very much!

  • October 10, 2012 at 11:23 am

    #1547762

    You're welcome 🙂

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

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

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