Post reply

Transferring SSIS packages

  • February 13, 2009 at 5:45 pm

    #126386

    Is there any way to transfer SSIS packages stored in MSDB from one server to another, for availability/DR purposes, aside from transferring the MSDB or using the deployment utility?

    Thanks,

    Scott

  • February 17, 2009 at 10:08 am

    #945300

    If you connect to Integration Services in SSMS on the server where the packages are stored, you can right-click on a package and select "Export Package..." which will let you choose a destination for a copy of the package.

    Greg

  • February 17, 2009 at 9:45 pm

    #945654

    Greg Charles (2/17/2009)

    If you connect to Integration Services in SSMS on the server where the packages are stored, you can right-click on a package and select "Export Package..." which will let you choose a destination for a copy of the package.

    Thanks, but I'm really looking for is an automated way to transfer all of the packages (that are stored in MSDB, not folder) from one server to another, to keep failover servers in sync. We logship the user databases.

  • February 19, 2009 at 7:13 am

    #946644

    Take a look in BOL for the DTUtil command line utility. It will let you move packages between MSDB and the file system and back.

  • February 19, 2009 at 9:16 am

    #946830

    Thanks, Chris. I hadn't used dtutil, but I'll check it out now.

    digitalox, read the discussion thread for this article. There's a post that describes how to do what you want: http://www.sqlservercentral.com/articles/SSIS+Package+Deployment/63263/

    Greg

  • February 19, 2009 at 12:06 pm

    #947000

    Thanks so much, I've been looking into this on and off for quite a while and never seen this solution.

    --

    Scott

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

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