Post reply

Smart way to export mutiple SSIS packages to File system and may be import back

  • March 16, 2011 at 3:43 pm

    #234115

    I have nearly 50 SSIS Packages which need some editing. So I need to bring them back to file system so that i can open'em up in BI studio edit n import back into Server. They all are under MSDB(Stored Packages).

    Is there a better way to do this than right clicking 50 times and and exporting pne by one.

    Please help.

    [font="Verdana"]
    Today is the tomorrow you worried about yesterday:-)    [/font]

  • March 17, 2011 at 4:53 am

    #1299860

    Yes, you can script it out using the dtutil utility.

    http://msdn.microsoft.com/en-us/library/ms162820.aspx

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

  • March 18, 2011 at 7:56 am

    #1300508

    Another possibility is to consider the use of source control software so you can make changes over time to local/checked-in packages and re-deploy them as-needed back out to msdb. That way, you don't have to script them out, edit them, and then get them back out to the server each time you need to make a change. You'll have a local copy that's version-controlled and can re-deploy updated packages.

  • March 18, 2011 at 8:29 am

    #1300535

    It seems that Powershell can do it too. See here.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • March 22, 2011 at 12:16 pm

    #1302072

    Phil Parkin (3/18/2011)

    It seems that Powershell can do it too. See here.

    Phil, looks like the link is broken, do you have an alternate link ? Thanks

    [font="Verdana"]
    Today is the tomorrow you worried about yesterday:-)    [/font]

  • March 22, 2011 at 1:48 pm

    #1302147

    The link works perfectly here.

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

Viewing 6 posts - 1 through 5 (of 5 total)

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