Post reply

Modifying SSIS package stored in File Systesm

  • June 11, 2014 at 11:46 am

    #286419

    Hi,

    I have a ssis package stored in file system and I need to modify this package.

    How can I do this?

    THanks.

  • June 11, 2014 at 12:45 pm

    #1720875

    If you already have a Visual Studio solution that contains the package, open that one and edit the package.

    If not, either create a new solution or use an existing one and add the package to that solution.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • June 12, 2014 at 8:41 am

    #1721094

    I don't have the package. It was a very old one and I recently joined in the company and the previous DBA might have had it but now I can see the package in file system under stored packages on management studio when I connect to SSMS as an admin.

    If I right click on the package I am getting an option 'Import Package'.

    But how can I download the stored package?

    Thanks,

    Hari.

  • June 12, 2014 at 11:44 pm

    #1721317

    sql_novice_2007 (6/12/2014)

    I don't have the package. It was a very old one and I recently joined in the company and the previous DBA might have had it but now I can see the package in file system under stored packages on management studio when I connect to SSMS as an admin.

    If I right click on the package I am getting an option 'Import Package'.

    But how can I download the stored package?

    Thanks,

    Hari.

    There should be an export option as well.

    Import and Export Packages (SSIS Service)

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • June 13, 2014 at 10:40 am

    #1721566

    I am not seeing the export option even though I connected to SSMS as an administrator and I have sysadmin privileges.

    Thanks.

  • June 13, 2014 at 11:51 am

    #1721604

    Can you take a screenshot of the context menu that you get when you right click on the package?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • June 13, 2014 at 12:23 pm

    #1721624

    sql_novice_2007 (6/13/2014)

    I am not seeing the export option even though I connected to SSMS as an administrator and I have sysadmin privileges.

    Thanks.

    You have to use BIDS or SSDT, not SSMS. SSMS has no option of editing/developing SSIS packages.

    😎

  • June 14, 2014 at 1:21 am

    #1721710

    Eirikur Eiriksson (6/13/2014)

    sql_novice_2007 (6/13/2014)

    I am not seeing the export option even though I connected to SSMS as an administrator and I have sysadmin privileges.

    Thanks.

    You have to use BIDS or SSDT, not SSMS. SSMS has no option of editing/developing SSIS packages.

    😎

    Yes, but you need SSMS to find the package stored on the server and export it to your filesystem so you can edit it with BIDS 😉

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 8 posts - 1 through 7 (of 7 total)

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

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy