Post reply

Short cut for migrating SSIS packages?

  • May 22, 2012 at 4:20 am

    #274324

    Hi All,

    We have to create some standard DBA maintenance plans everytime a new SQL server is installed, is there any shortcut through which I can copy those plans from the server where they already exist to the new one?

    I know shortcut for copying DTS packages but can't find one for SSIS packages.

  • May 24, 2012 at 12:19 pm

    #1492714

    If you are using the same .dtsx file, you can either import it into a new BI project, or use the same project repeatedly. Deploy the SSIS package to the new instance after the necessary changes have been made. I.E. any connection manager changes.

Viewing 2 posts - 1 through 1 (of 1 total)

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