Post reply

Copy the .dtsx file to backup an SSIS package?

  • August 13, 2008 at 7:37 am

    #130642

    Can a person simply copy the .dtsx file to a separate directory that gets backed up by the system administrator each night? the original SSIS package, or are there additional associated files that need to get copied?)

    Or, is there a better idea for backing up SSIS packages, so that their contents are preserved?

    Thanks,

    Randy

  • August 13, 2008 at 7:42 am

    #857410

    you only need to back up the .dtsx file, there are no associated files included.

    another option is to deploy the packages to the msdb, where the packages will be included in the backup of that database

    tom

    Life: it twists and turns like a twisty turny thing

  • August 13, 2008 at 8:00 am

    #857425

    As mentioned, only the dtsx is important. However, backing on the sln file and others in the folder is a good idea because you don't have to recreate the solution. Not the end of the world though.

    I disagree with the MSDB option though. I am starting a "no MSDB campaign" but that's a different topic 🙂

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

  • August 13, 2008 at 8:17 am

    #857447

    Thanks for the responses, much appreciated.

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

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