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