Setting package upgrade options in the designer


You can set a couple of package upgrade options in the designer through the SSIS options page (Tools -> Options…)

image

These defaults will be used anytime you upgrade a 2005 package through the designer.

See my post about the Upgrade Wizard for more details on these options.

You’ll also a couple of other things on this page:

  1. You can set the default language to use for script tasks /components
  2. The "comfirm" delete option on the left (the typo has since been fixed!)

Comments (2)

  1. SSIS Stuff says:

    We tried to make our package upgrade as seamless as possible, but one problem we’ve seen people running